How to access HANA Procedure From Information Design Tool(IDT)

[former_member383962]

Hi Friends...

i'm Trying to access my Store Procedure in hana from IDT.. But i can't... i can see the tables, views, and Table Types but Store Procedure is not available to access..

Is there is anyway to access it...

[former_member383962 · Accepted solution]

Hi Experts,

I got an answer for my question.

 WITH RESULT VIEW <view_name> <view_name> ::= <identifier>

It Specifies the result view to be used as the output of a read-only procedure.

Example 2 - Creating an SQL Procedure with Result View:

createprocedure"KABIL_PRACTICE"."ARRAY_UNNEST_SIMPLE_With_Result_View"(OUT result "KABIL_PRACTICE"."TTYPE")
LANGUAGE SQLSCRIPT READS SQL DATA with result view "KABIL_PRACTICE"."ARRAY_UNNEST_RES"
as begin 
declare ID integer array :=array(1,2);
declare NAME nvarchar(65) array := Array ('name1','name2','name3');
result = UNNEST(:ID,:NAME);
end;

To Call a Procedure:

select * from"KABIL_PRACTICE"."ARRAY_UNNEST_SIMPLE_With_Result_View"

And then Open your Information design Tool (IDT) there you may get the result of the procedure as in a "View name " which is you mentioned in your procedure under your schema....

thank you...