Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    86

    Unanswered: ORA-01403: no data found

    I have a stored procedure that is processing data.

    It has run many times, however we exported and imported to another instance and now when the procedure runs, I get the following error message when it tries to do the fetch.

    ORA-01403: no data found

    I check the cursor it is failing on, and run the SQL statement from the cursor , it returns thousands of records.

    Anybody got any idea what the problem could be?

    I'm running Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You will never get ORA-01403 (no data found) raised from a cursor, so that isn't where your problem lies. There are 2 possibilities:

    1) (The most common): a "SELECT ... INTO ..." statement that found no rows.

    2) An attempt to access a collection element that was never initialised, e.g.:

    x := my_array(42);

  3. #3
    Join Date
    Feb 2004
    Posts
    86
    It is somehting to do with a difference between the two schemas, I have used the orginal without any problem. I even count the table rows between the two to see if they match, and they do. I'm in the process of doing a schema compare to see the difference. This is totally wierd.

Posting Permissions

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