Re: Which PRAGMA to use? "Func. does not guarantee not to update db"

Simon Taylor wrote:
>
> Can anyone comment on this:
>
> When I call a plsql function from sqlplus (in a select statement), and the
> function is part of a PL/SQL package, I get the following error:
>
> ORA-06571: Function F_GET_SCCN_ID does not guarantee not to update database
>
> Which translates to:
>
> 06571, 00000, "Function %s does not guarantee not to update database"
> // *Cause: A plsql function that does not have a pragma asserting that it
> // does not write any database state is referenced in a sql
> statement.
> // Such functions cannot be used in sql statements.

I have the same problem, please send me the solution too. I really need the answer.

PLEASE HELP!!!!

-- 

Thanks in advance, Inacio

   __
  / /  __ _  __ _ __ __ __         \|/                       
 / /_ / // \/ // / / \ / /        (. .)                      
/___//_//_/\_//___/ /_/\_\---ooO---(_)---Ooo--------------+
     +                                                    +
     +  e-mail: gilberto.j.inacio_at_telecom.pt              +
     +  URL: http://www.geocities.com/SiliconValley/6566  +
     +                                                    +
     +----------------------------------------------------+