Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL, dynamic calling a procedure
Botschek Herbert 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
I would think you should be able to do it using the dynamic sql
package dbms_sql.
Loyal Received on Fri Sep 19 1997 - 00:00:00 CDT