Skip to Content

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

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...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 07, 2017 at 06:54 AM

    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...

    Add comment
    10|10000 characters needed characters exceeded