Re: SQL Help

You need to use an indicator variable to determine if a NULL was returned. EX.
select x into :var1:var1_ind ....

if :var1:var1_ind IS NULL ...

R.

Paul Davies wrote:

> 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 - 15:39:21 CDT