Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> User defined function in SQL Expression
I am trying to create a function which will be used
in the WHERE clause and which will use dynamic sql.
I know that when calling a function from an
SQL Expression the function must have
PRAGMA RESTRICT_REFERENCES(function_name, WNDS)
My problem is I can not state the pragma WNDS as
DBMS_SQL parse and execute do not have these
restrictions.
The function I am trying to create will only ever
SELECT never INSERT, UPDATE or DELETE data.
Can anyone help, any help will be greatly appreciated.
Thanks in advance
Claire.
Received on Wed Oct 21 1998 - 00:00:00 CDT