SQL Help

When I have a select statement:

select COL_A into a_variable from TABLE where TABLE.COL_B = value

IF a_variable = null....

within a PLSQL procedure, the procedure bombs out if no values are found. In Sybase, however, a_variable would be set to null. Is there a simple way I can force the select to behave like this in Oracle - ie it continues if no values are found and sets a_variable to null?

Help appreciated

Paul Received on Thu Apr 22 1999 - 13:55:02 CDT