Xref: alice comp.databases.oracle.misc:38010
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!news1.tor.metronet.ca!nntp1.savvis.net!newsfeed.slurp.net!not-for-mail
From: "Goyito" <geeslin@oct.net>
Newsgroups: comp.databases.oracle.misc
Subject: Why am I violating this pragma?
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <96zr3.845$JM3.3541@newsfeed.slurp.net>
Date: Sun, 8 Aug 1999 09:42:41 -0500
X-Trace: newsfeed.slurp.net 934198789 216.207.207.223 (Mon, 09 Aug 1999 06:39:49 CDT)
NNTP-Posting-Date: Mon, 09 Aug 1999 06:39:49 CDT

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.'

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@mslc.com