Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which PRAGMA to use? "Func. does not guarantee not to update db"

Re: Which PRAGMA to use? "Func. does not guarantee not to update db"

From: crosby <crosby_at_po.pacific.net.sg>
Date: 1997/01/20
Message-ID: <5bvl52$j1i@newton.pacific.net.sg>#1/1

To be able to call database function from sql statement you have to write pragma in your function definition as follows in your package specification

PRAGMA RESTRICT_REFERENCES (your function name, WNDS,WNPS) ;

Hope this helps you.

In case if there is any problem
pleas contact me at my
email address

rajeshws_at_post1.com

OR

rajeshws_at_socgen-crosby.com

Cheers
Rajesh

Cheers
Rajesh Received on Mon Jan 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US