Pragma Restrict References [message #37056] |
Sun, 13 January 2002 21:53 |
Angie Tan
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
Hi,
In one of my select statement, i need to call an function in procedure a. however it keep giving error "violate associated pragma".
However, if i put that function in procedure b, there was no error at all. Pls advise.
Thanks
Regards, Angie
|
|
|
Re: Pragma Restrict References [message #37057 is a reply to message #37056] |
Sun, 13 January 2002 23:52 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
Hi,
Not all the stand-alone or package function can be called during execution of SQL statement.It should meet certain restrictions and it is called "PURITY LEVELS". There are 4-types of purity level :RNDPS,WNDS,RNPS,WNPS.
So, your function is not meeting those criteria.change your function to do so.
thanx
pratap
|
|
|
Re: Pragma Restrict References [message #37061 is a reply to message #37057] |
Mon, 14 January 2002 08:07 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
pratap is right. In 8i, the use of Pragma Restrict References is not so important. The pl/sql compiler tries to determine this itself, but that does not mean that you can call whatever function you want from inline SQL.
|
|
|
|