Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Accessing Functions that are part of a Package
Just re-create your function with the pragma that prevents the database from being updated, I mean WNDS restriction: pragma restrict_references(<your function name>, WNDS);
Edward Mikhaylots,
Izmailovo, Moscow, Russia,
Telesoft Russia Co.
Ajay Mirmira wrote:
>
> I would like to know how to access functions that are part of a
> package. I have created a package pkg_functions and one of the
> functions in this package is called validate_date. This function
> validates a 8 digit number in the format yyyymmdd. When I created this
> function as a stand alone unit, it worked fine, but when it is part of
> the package, I get the following error:
>
> ERROR at line 1:
> ORA-06571: Function VALIDATE_DATE does not guarantee not to update
> database
>
> The package specification and body compile with out any errors. I
> would be grateful if anybody can help me.
>
> Ajay Mirmira
> ORACLE Applications Programmer
> Ohio University
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT
![]() |
![]() |