PL/SQL for searching

hi all..

i'm a beginner in using oracle9i form for web dev and ..i have problem to create searching button (pl/sql code) where the record that i tried to find using the text item..can somebody help me

example:
textitem10 is value that will be keyin in the form
----
declare
textitem10 number(2);

begin
select empno,ename,edept from emp
into :textitem1,
:textitem2,
:textitem3
where empno = 'textitem10'
end;
execute_query;

but my coding is doesn't work..
found error "FRM-40735: WHEN-BUTTON-PRESSED trigger araised unhandled exception ORA-01403"..any body know help me..pleaze
thanks
flyguysOriginally posted by flyguys
hi all..

i'm a beginner in using oracle9i form for web dev and ..i have problem to create searching button (pl/sql code) where the record that i tried to find using the text item..can somebody help me

example:
textitem10 is value that will be keyin in the form
----
declare
textitem10 number(2);

begin
select empno,ename,edept from emp
into :textitem1,
:textitem2,
:textitem3
where empno = 'textitem10'
end;
execute_query;

but my coding is doesn't work..
found error "FRM-40735: WHEN-BUTTON-PRESSED trigger araised unhandled exception ORA-01403"..any body know help me..pleaze
thanks
flyguys
ORA-01403 means "No data found" - i.e. the select returned no rows.

This is probably because you should have written it like this:

select empno,ename,edept from emp
into :textitem1, :textitem2, :textitem3
where empno = :textitem10;

As written, it was looking for an emp record with an empno value of 'textitem10', which of course does not exist.