Raising no_data_found
77181Jan 29 2005 — edited Feb 1 2005Executing anonymous block (see below) does not report ORA-01403 to the host environment.
I am using NCOCI in Delphi, but I had the same problem with ADO.
declare
a varchar2 (100);
begin
select dummy
into a
from dual
where 1= 0;
end;
The following code works as expected:
declare
a varchar2 (100);
begin
select dummy
into a
from dual
where 1= 0;
exception
when no_data_found then
raise_application_error (-20000, SQLERRM);
end;
Thanks for any suggestion, Dab