Invoking Procedure from BODS with OUT (output) parameters

[former_member205887]

Hi Experts,

Need your help to invoke Oracle DB Procedure having output parameters from BODS Script

--Thanks

[former_member205887 · Accepted solution]

Procedure Code:

create or replace PROCEDURE findMin(x IN number, y IN number, z OUT number) IS

BEGIN

   IF x < y THEN

      z:= x;

   ELSE

      z:= y;

   END IF;

END;

Below Syntax worked....

SQL('Datastore_Name','DECLARE a number :=10;  b number :=20;   c number;  begin  FINDMIN(a,b,c); end;');

[Former Member · Accepted solution]

Hi Balakrishna,

Nice solution, but how do you assign / get your out-variable c further out to use in BODS?   

Regards,

- jem

[Former Member]

Hi Balakrishna,

IF you want to execute the stored procedure from script first import the SP into your data store first and you can try the below scripts, i am not sure that it will works kindly try and let me know.

Datastore Name.Owner.Procedure_Name( $Var_1 , $Var_2 );

or

SQL('Datastore_name',exec sp_xxx);

Thanks and regards,

subbu CH.

[former_member205887]

Hi Subbu, i tried your suggested approach, still i am getting same error...