I have a stor proc as follow

...
select valueA from tableA where fieldA = 2 into :varA;

select valueA from tableA where fieldA = 1 into :varA;
...

if first statement finds something then varA is set to that value. And if
the second statement doesn't find anything then I expected it to be set
to null, but that's not the case. It has the value assigned in first select
statement.

Is this OK ?


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz