Re: ORA-06571 HELP!! HELP!! HELP!! HELP!!

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_at_arrakis.es
> ismael_at_eitb.com
Received on Fri Oct 10 1997 - 00:00:00 CDT