Re: PL/SQL, dynamic calling a procedure

On Thu, 18 Sep 1997 21:05:09 +0200, Botschek Herbert <botschek_at_saw.ch> wrote:

>Hi
>does anyone know how to call dynamically a stored procedure
>in a stored procedure and the procedure which will be
>called has a out parameter.
>
>
>
>------------------------------------------
>Prozedure which will be called: GDM.fahrt(v_name OUT)
>
>PROCEDURE the_caller
>
> cur_id number;
> statement varchar2(200);
>
>BEGIN
>
> statement := 'BEGIN GDM.fahrt(:v_name); end;';
>
> DBMS_SQL.open_cursor;
>
> DBMS.parse(cur_id, statement, DBMS_SQL.V7);
>
>
> .....
> ...
> ...
>
>==> hier, I down't know how to retrieve the Value
> from the variable : v_name !!!!
>
>
>
>Thanks for the help..
>
>
>Herbert

Hi Herbert,

have a look at the procedures DBMS_SQL.BIND_VARIABLE and DBMS_SQL.VARIABLE_VALUE. These allow to define and to retrieve the value of bind variables in an anonymous PL/SQL block executed dynamically.

Feel free to email me if encounter any further problems.

Hope this helps,
Peter

Peter Schneider
pschneider.ctj_at_metronet.de Received on Sat Sep 20 1997 - 00:00:00 CDT