Andrejm,

Thanks for your reply.

I have a stored procedure that uses the "SELECT c_True INTO FROM WHERE ..." statement and has always compiled when using Oracle8i. Now we have migrated to Oracle9i and the compilation of this stored proc has failed with the error I mentioned earlier.

I do need to do this using a SELECT statement because the WHERE clause determines whether the variable should be set to true.

Regards,
Javi