PL/SQL, dynamic calling a procedure

From: Botschek Herbert <botschek_at_saw.ch>
Date: 1997/09/18
Message-ID: <34217B65.4C9@saw.ch>#1/1

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 Received on Thu Sep 18 1997 - 00:00:00 CDT