DBMS_SQL and PRAGMA RESTRICT

From: Jonathan Waland <jonathan.waland_at_vf.vodafone.co.uk>
Date: Fri, 12 Jun 1998 15:48:58 +0100
Message-ID: <35813FDA.C8A48EA4@vf.vodafone.co.uk>

*****Posted for a collegue******

DBMS_SQL and PRAGMA RESTRICT_REFERENCES

Can anyone help???

I wish to use a function in a select statement, the function input parameter is a column in which a SQL query resides as a text string, the output will be a numeric.

I need to use DBMS_SQL to execute the IN parameter as a SQL statement, I also need to use PRAGMA RESTRICT_REFERENCES (WNDS) as the function will be called in a SELECT, however it appears that I can't use both!!!

When I try to compile my package the following is returned

PLS-00452: Subprogram 'XXXXXX_XXXXXX' violates its associated pragma

Even though my SQL Query is a simple SELECT COUNT(*)

Any ideas? Does DBMS_SQL write to the database?

Phillip Reid
Vodafone Ltd.

*****Posted for a collegue******
Received on Fri Jun 12 1998 - 09:48:58 CDT