Problems with dbms_sql.parse (ora-6571) [message #369659] |
Mon, 14 February 2000 17:06 |
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 |
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.
|
|
|