Home -> Usenet -> comp.databases.oracle -> call functions using dynamic sql in SELECT statement

call functions using dynamic sql in SELECT statement

From: Dennis Lo <dlo_at_pop.jpl.nasa.gov>
Date: Tue, 18 Aug 1998 19:04:08 -0700
Message-ID: <6rdbml$8ib_at_netline.jpl.nasa.gov> 





I have one situation and would appreciate if someone can shed some lights on
it.



I tried to use some of the functions I wrote previously in my SELECT
statement.  These functions are mostly built with dynamic sql, the dbms_sql
stuff.  I declare the directive restrict_references(<function_name>, WNDS)
after the function specification.  But when I compile the package body, the
following error message is returned:



    PLS-00452: Subprogram <function_name> violates its
    associated pragma



Does it mean that  functions built with dynamic sql will not be accessible
in SELECT statement?



Please help.
Received on Wed Aug 19 1998 - 04:04:08 CEST












Original text of this message