Re: SQL-callable functions

Hi Karen.

I got a similar compile error because a function had dbms_output.put_line in it (for debugging!)

Take a closer look at your code. Are you sure you are not updating the database?

In article <826048375.4526.0_at_ccvm.sunysb.edu>, Karen Huguley <khuguley_at_M AIL.CASI.STI.NASA.GOV> writes
> Hi,
>
> I wrote a standalone (i.e., not packaged) PL/SQL
> function that is callable by SQL. The function does not update
> any tables (it reads one, though) - only performs calculations.
> When I call it from SQL, I get: ORA-06571 "Function CALC_WORKDAY
> does not guarantee not to update database".
>
> So, I put this function in a package with the following specification:
>
> create or replace package abc_pkg is
> function calc_workday (datein IN date) return number;
> PRAGMA RESTRICT_REFERENCES (calc_workday,WNDS);
> end abc_pkg;
> /
>
> Now, when I recompile, I get: "PLS-00452: Subprogram 'CALC_WORKDAY'
> violates its associated pragma".
>
> What am I doing wrong? I can email the function if necessary.
> Environment: RDBMS v7.1.6, PL/SQL 2.1.6.2.0, Solaris 2.4.
>
> Thanks in advance,
> Karen
> DBA, NASA Center for Aerospace Information
> khuguley_at_casi.sti.nasa.gov
Good luck,
--
John Thomas Received on Mon Mar 04 1996 - 21:34:02 CST