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,
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.