Handling Ora 6571 error...

From: John F Duggan <duggan_at_spock.ecs.umass.edu>
Date: 6 Jul 1998 15:22:02 GMT
Message-ID: <6nqq2q$32s$1@risky.ecs.umass.edu>

When attempting to execute a PL/SQL function which contains a select statement of the form

	select upper(column) into variable from table 
	where upper(in_param) = upper (column);

I get ORA error 6571, Function %s does not guarantee not to update database Is this due to the potential for more than one row to match this where con- dition?

The output from oerr ora 6571 is:

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.

// *Action: Recreate the function and/or the functions it calls with the pragma
 

Can I setup a pragma to handle this?

Thanks for your time,

John Duggan
Systems Programmer

---

 John Duggan                       Internet : duggan_at_zonker.ecs.umass.edu
 Engineering Computer Services
 Univ. of Massachusetts            Phone    : (413) 545-1580
 Amherst, MA 01003                         
----------------------------------------------------------------------------

Received on Mon Jul 06 1998 - 10:22:02 CDT