DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora-01403

  1. 10-28-2003, 06:54 AM #1
    bensmail
    bensmail is offline Senior Member
    Join Date
    Mar 2002
    Posts
    303

    Ora-01403

    I have a PL/SQL procedure. When i execute it i have this error:
    ORA-01403.
    How can i correct this
    Reply With Quote Reply With Quote
  2. 10-28-2003, 07:36 AM #2
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    use:

    begin
    select ....

    exception
    when NO_DATA_FOUND then
    raise_application_error(-20000,'No Data Found');
    end;
    /
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width