Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    malaysia
    Posts
    2

    Unanswered: 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
    flyguys

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: PL/SQL for searching

    Originally 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •