Home » RDBMS Server » Server Administration » Problems with dbms_sql.parse (ora-6571)
Problems with dbms_sql.parse (ora-6571) [message #369659] Mon, 14 February 2000 17:06 Go to next message
Sergio Klimberg
Messages: 1
Registered: February 2000
Junior Member
I'm developing a new function using dbms_sql.parse.

When I call this function from a select it displays the following error :

ora-6571 :
"Function %s does not guarantee not to update database"

This dbms_sql.parse is used for a select , not for update.
Re: Problems with dbms_sql.parse (ora-6571) [message #369660 is a reply to message #369659] Tue, 15 February 2000 05:23 Go to previous message
Marius Raicu
Messages: 2
Registered: February 2000
Junior Member
If you want to call function from sql statement(select,update) you must put function in a package and specify in package specification the purity level of the function
pragma restrict_references(func_name,WNDS);
If you parse a ddl you cannot call this function from sql, dbms_sql.parse on ddl statements issue an implicit commit.
Previous Topic: Translate a numérique to date
Next Topic: Self Join- Corelated subquery
Goto Forum:
  


Current Time: Fri Mar 29 05:24:17 CDT 2024