Help Again, Something about Dynamic PL/SQL

From: lkw <lkw_at_axiomatique.com>
Date: Fri, 17 Dec 1999 10:48:28 +0800
Message-ID: <83c8ib$2q6$1@newton3.pacific.net.sg>

hi everybody,

at first i would like to say thanks to M.Armaghan and Bob Bain for telling me that there is a way to construct dynamic SQL statements in stored proc.

i have tried them and found them useful. But right now i faced another problem which is that i need to return a cursor from the DBMS_SQL.COLUMN_VALUE or DBMS_SQL.VARIALBLE_VALUE. i always get compilation errors like

*PLS-00306: wrong number or types of arguments in call to 'COLUMN_VALUE'*
or
*PLS-00306: wrong number or types of arguments in call to 'VARIABLE_VALUE'*

So i guess that izzit DBMS_SQL package doesn't support cursor variable? if yes, how shall i declare them in the first place?

Any helps would be greatly appreciated! thanks!

lkw. Received on Thu Dec 16 1999 - 20:48:28 CST