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

Home -> Community -> Usenet -> c.d.o.server -> Re: Restrict Pragma

Re: Restrict Pragma

From: david_g <david_l_gouldNOdaSPAM_at_yahoo.com.invalid>
Date: Wed, 26 Jan 2000 06:20:04 -0800
Message-ID: <06889872.953c1afc@usw-ex0106-048.remarq.com>


continuing...

You use the pragma restict references as stated in order to guarantee that the function will on update the database (WNDS - Write No Database State, WNPS - Write No Package State). This avoids the error 'Function does not guarantee not to update database' when using the function in a select statement.

Regards,
David.

Received on Wed Jan 26 2000 - 08:20:04 CST

Original text of this message

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