Link to home
Start Free TrialLog in
Avatar of xsysys
xsysys

asked on

Need help in executing dynamic stored procedure in PB

Hi Everybody,
 
I am using ORACLE( 10g Release 2 ) for my Power Builder( PB8 ) application.
 
I have created following stored procedure
 
CREATE OR REPLACE PROCEDURE SP_out_parm_demo( OUT_param_value OUT varchar2(10))
as
Begin
 OUT_param_value := '100';
END;
 

and i want to execute this stored procedure dynamically at runtime,
as any stored procedure can be executed at runtime( the Stored procedure name will be decided at the runtime ) which is having only one varchar output parameter( the above procedure is just an example of the Stored procedure ).
 

In this case how can i execute the stored procedure in PB script and return the value of the OUTPUT PARAMETER.
 

can any body help me, how can i execute this dynamic stored procedure( syntax ) ?

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of gajender_99
gajender_99

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial