Re: Question on DBMS_SQL package

John, Sven-Olaf (and anyone else who may be interested),

   Just got the 'Official' answer on this one from Oracle. You cannot call a function that is capable of changing the database from a SELECT statement, likewise you cannot call a function which calls a function that is capable of changing it from a SELECT. In addition you cannot create a package with a pragma restriction 'tighter' than the pragma restriction of the package of any function it contains. Since both DBMS_SQL.PARSE() and DBMS_SQL.EXECUTE are capable of changing the database, neither can be called from a function used in a SELECT. or used in a packaged function with a more restrictive pragma, thus TCOUNT in a package failed for the same reason. At least now we know why it won't work.

Hope you find this interesting,

Paul

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 17 2000 - 22:22:54 CET