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: Help on ORA-06573: Function name modifies package state ?????

Re: Help on ORA-06573: Function name modifies package state ?????

From: <Jiri.Felcman_at_noofs.abb.no>
Date: Thu, 18 Nov 1999 12:41:55 GMT
Message-ID: <810s6j$kbc$1@nnrp1.deja.com> 





Add your function to a package and declare a pragma for it (for the
function): PRAGMA RESTRICT_REFERENCES (my_function,WNDS,WNPS);.
 In select you are not allowed to use functions that could change DB
data - you "promis" this in the pragma assignment (WNDS). If you are
interested in details I can send them in next e-mail or look at p.557
book: Oracle PL/SQL Programming pub. by O'REILLY . Hope this is enough.



Jiri




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Thu Nov 18 1999 - 06:41:55 CST












Original text of this message













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