From: Lando <MarkL@quebim.com>
Subject: Re: ORA-06571  HELP!! HELP!! HELP!! HELP!!
Date: 1997/10/10
Message-ID: <343E81B4.8B628495@quebim.com>#1/1
References: <343EB828.7C44@arrakis.es>
X-Priority: 3 (Normal)
X-Complaints-To: usenet@pppl.gov
X-Trace: tom.pppl.gov 876511656 20869 (None) 198.140.134.42
Organization: Princeton Plasma Physics Laboratory
Reply-To: MarkL@quebim.com
Newsgroups: comp.databases.oracle.misc



Disregard my earlier post (missed the the INSERT part), you can't do an
insert with a function.


Ismael Perez wrote:

> 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@arrakis.es
>          ismael@eitb.com