Hello All,
is null is not working even if the select statement didnt bring any results. Count is working
X varchar2(100) = '';
Xcnt number;
begin
select XID into X from XTable where ID=1;
-- It is working if i count it and change the condition to check if the Xcnt=0 then Xcnt>0 then
end;
if X is NULL
then
-----
end
if X is not null
then
---
end;