Re: ORA-06571 HELP!!! HELP!!! HELP!!!
From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/10/10
Message-ID: <19971010223601.SAA10110_at_ladder01.news.aol.com>#1/1
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
>Subject: ORA-06571 HELP!!! HELP!!! HELP!!!
>From: Ismael Perez <perez32_at_arrakis.es>
>Date: Fri, Oct 10, 1997 19:21 EDT
>Message-id: <343EB876.148E_at_arrakis.es>
>
>Ismael Perez wrote:
>
>Hi All,
>
> I have a problem with a Function. I´m using a function that INSERT
>records in a Table.
>The function is in a Package, the function Return a NUMBER. When I
>called this function from
>an SQL expression, such as:
> SELECT <function-name> FROM DUAL;
>
>Oracle return this Error:
> ORA-06571 Function <function-name> does not guarantee not to Update
>Database
>
>How can I resolve this Error...
>
> Thanks
>
> e-mail: perez32_at_arrakis.es
> ismael_at_eitb.com
>
>
>
>
>
>
>
Received on Fri Oct 10 1997 - 00:00:00 CEST
Date: 1997/10/10
Message-ID: <19971010223601.SAA10110_at_ladder01.news.aol.com>#1/1
Hi
In your package spec, after the function, you need a pragma
PRAGMA RESTRICT_REFERENCES
(<function name>,WNDS,RNDS,WNPS,RNPS);
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
>Subject: ORA-06571 HELP!!! HELP!!! HELP!!!
>From: Ismael Perez <perez32_at_arrakis.es>
>Date: Fri, Oct 10, 1997 19:21 EDT
>Message-id: <343EB876.148E_at_arrakis.es>
>
>Ismael Perez wrote:
>
>Hi All,
>
> I have a problem with a Function. I´m using a function that INSERT
>records in a Table.
>The function is in a Package, the function Return a NUMBER. When I
>called this function from
>an SQL expression, such as:
> SELECT <function-name> FROM DUAL;
>
>Oracle return this Error:
> ORA-06571 Function <function-name> does not guarantee not to Update
>Database
>
>How can I resolve this Error...
>
> Thanks
>
> e-mail: perez32_at_arrakis.es
> ismael_at_eitb.com
>
>
>
>
>
>
>
Received on Fri Oct 10 1997 - 00:00:00 CEST