getting error ora-01403 data not found when i execute a simple select statement [message #18917] |
Thu, 21 February 2002 03:33 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
when i execute the below code,i get the error as ora-01403,data not found.How to overcome this.
Actually there is no matching record,just i want to check,if any record is there then it should return me the idcity else it should not do anything(just printing nothing)
declare
city1 number;
begin
select idcity into city1 from city where
upper(dsnmcity) = upper('city11') ;
if sql%found then
dbms_output.put_line(city1);
else
dbms_output.put_line('not');
end if;
end;
|
|
|
|
|
|