| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: bind variables & dbms_sql in procedure/packages
Jared,
it is doable and I have done that. The worst part is you have to programmatically control everything it is it a pain in the you-know-where. Luckily a year ago, I trashed all that code and went for NDS ... Raj
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Jared.Still_at_radisys.com
Sent: Tuesday, March 30, 2004 5:01 PM
To: oracle-l_at_freelists.org
Subject: Re: bind variables & dbms_sql in procedure/packages
IIRC, you can't do that.
Consider the preparatory steps in using DBMS_SQL.
parse a cursor, define and\/or bind the columns and execute.
An unkown number of parameters kind of precludes the use of DBMS_SQL.
Better to use native dynamic SQL in this case IMO.
That's not to say that there isn't a convoluted method that could be
used
to accomplish this with DBMS_SQL, I think it *could* be done.
In the end though it would be very complex and offer no benefits over native dynamic sql, which would also execute faster.
I'm not offering any proof. Let someone else prove this is wrong, which
is
much easier than me proving it is correct. :)
HTH
Jared
 |
 |