Hello,
lets say i have a query like
select isin_no from test_asset where isin_no = 'CH0024899483';

and the query returns 'no data found' error ora-01403

can we compare like

if (select isin_no from test_asset where isin_no = 'CH0024899483') = 'ora-01403' then
...
end if;