Re: dynamic SQL question

Nedee & Co <nedee_at_club.innet.be> wrote in article <5b532s$156$2_at_news.be.innet.net>...
> Do u need to work in Pro*C ?
> The dbms_pipe package is a very good tool for dynamic SQL, so u can
> write your programs in PL/SQL. Just an idea...

Actually, the DBMS_SQL package might be a better bet. Specifically, it contains logic that enables PL/SQL to use dynamic SQL. There is a fax-back document that Oracle has that is pretty good. For 7.1 Oracle, the documentation is in the Documenation Addendum book. It has some inaccurate examples, though, so either get the fax document from Oracle or surf over the the White Papers page and see if they have anything on it. The package is similar to, but not quite like the PRO* precompilers. Received on Fri Jan 10 1997 - 00:00:00 CST