Re: PL/SQL Question - Calling a procedure dynamically

From: Marc Billiet <Marc.Billiet_at_village.uunet.be>
Date: Thu, 27 Aug 1998 21:19:58 +0200
Message-ID: <6s4c15$3f4$2@xenon.inbe.net>

Sorry for the late reply, but I think you shouldn't forget to add (at the end of course):

dbms_sql.close_cursor(sql_cur);

(I'm currently having problems with unclosed cursors and ORA-01000 error messages, so I'm very keen on it)

Marc

Lothar Armbrüster wrote in message
<1312.536T1004T12162947_at_rheingau.netsurf.de>...
>marqmarq schrieb am 20-Aug-98 17:10:48
>zum Thema "PL/SQL Question - Calling a procedure dynamically":
>
>>Hello,
>
>declare
>
>sql_cur integer;
>ignore integer;
>
>begin
> sql_cur := dbms_sql.open_cursor;
> dbms_sql.parse(sql_cur,'begin packname.procedname(TRUE); end;',
> dbms_sql.v7);
> ignore := dbms_sql.execute(sql_cur);
>end;
>
Received on Thu Aug 27 1998 - 14:19:58 CDT