Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Function does not guarantee... using DBMS_SQL package.
On Mon, 24 Jul 2000 18:06:28 GMT, Hakan <heren_at_home.com> wrote:
>hi,
>
>dbms_sql is a package that does not guarantee 'WNDS'. So does your fnc.
>'f' .
>That's the reason.
Does that mean what I am attempting is impossible? according to http://oradoc.photo.net/ora8doc/DOC/server803/A54642_01/ch7b.htm I need to use a pragma restrict_references(f,WNDS) to enable me to call the packaged function, so why can't I assert that my function whilst it uses DBMS_SQL, will not ever do any writes I'm only using it to perform reads.
What options do I have to achieve this?
Jim. Received on Mon Jul 24 2000 - 00:00:00 CDT