Simple question ...

Hi All!

The following command :

SELECT myField INTO myVariable FROM myTable WHERE myCondition;

 generates an error if there is no record satisfying the condition "myCondition".

I would like to be able to do something like:

SELECT myField INTO myVariable FROM myTable WHERE myCondition ; if myVariable is null then

• do something else
• do something else end if ;

Is there any way to do this without having to handle the exceptions ?

I read somewhere that it not advisable to rely the code of the procedure on exceptions for getting common results.

ernest Received on Fri Aug 06 2004 - 08:13:24 CDT