Re: Executing stored SQL statements

DBMS_SQL is a package for using dynamic sql in pl/sql. Works fine, but you need to use bind variables with it. That is, don't just create a SQL string with your predicate values all resolved and plugged in. Oracle will go nuts parsing each statement unless you use bind variables. There is now some pretty good documentation on the subject, so read first. Received on Sun Jul 13 1997 - 00:00:00 CEST