Need help in executing dynamic stored procedure in PB
Posted on 2006-06-21
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))
OUT_param_value := '100';
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 ) ?