Re: Why am I violating this pragma?

A copy of this was sent to "Goyito" <geeslin_at_oct.net> (if that email address didn't require changing) On Sun, 8 Aug 1999 09:42:41 -0500, you wrote:

>Hello Everybody!
>
>I have a function that I want to be able to access in an SQL statement.
>That function wraps a longer procedure that does some calculations and
>returns a set of values using IN OUT parameters. The function sends me the
>one value I'm interested in. My problem is that the PRAGMA
>RESTRICT_REFERENCES(function, WNDS); fails. I get a message that 'The
>function violates it's associated pragma.'
>

do you have the pragma on the procedure as well -- it needs to have its purity asserted as well.

>According to the documentation, when using this pragma, the function can do
>no INSERTs, UPDATEs or DELETEs and use no dynamic SQL. Neither the function
>nor the procedure it calls do any of these things. The procedure does,
>however, use a PL/SQL table to hold a list of static values that are used to
>compare against some of the values that the procedure has to calculate. Is
>the creation and use of that PL/SQL table a violation of the pragma? If
>not, what other possibilities are there?
>
>I would appreciate any help you could give me. I have to get this problem
>solved as soon as I can. I'm using Oracle version 7.3.
>
>Thanks in advance,
>
>Gregg
>geeslin_at_mslc.com
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Aug 08 1999 - 13:31:11 CDT