Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> User defined function in SQL Expression

User defined function in SQL Expression

From: Claire Brown <CBrown_at_PINDAR.COM>
Date: 1998/10/21
Message-ID: <362DA17E.8E366EE5@PINDAR.COM>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US