Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: User Defined function in SQL Expression
Claire Brown wrote:
>
> 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.
I think this has been up in this group before, the answer was that you cannot give the wnds-pragma to a function that is using dynamic sql.
Maybe there's another way to do what you are trying to do?
Njål
>
> Thanks in advance
> Claire.
Received on Wed Oct 21 1998 - 19:42:57 CDT