Home » Other » Client Tools » URGENT - Error while executing package procedure
URGENT - Error while executing package procedure [message #38621] Wed, 01 May 2002 06:37 Go to next message
Vijay
Messages: 116
Registered: September 1999
Senior Member
Hi,

I am encountering the following error while executing a package procedure :-

ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "VJ.AL560", line 2306
ORA-06512: at "VJ.AL560", line 60
ORA-06512: at line 1

On refering to ORA-01403, the error message is

Cause: In a host language program, all records have been fetched. The return code from the fetch was +4, indicating that all records have been returned from the SQL query.

Action: Terminate processing for the SELECT statement.

Am unable to understand this message. Could you pls explain what this error indicates. My package procedure works fine for certain cases.

Thanks and Regards
VJ
Re: URGENT - Error while executing package procedure [message #38628 is a reply to message #38621] Wed, 01 May 2002 09:58 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
At line 2306 of the package body, there is a SELECT...INTO statement that is not finding the one row it is expecting to find. A SELECT...INTO statement will throw an exception if it finds:

no row: NO_DATA_FOUND
more than one row: TOO_MANY_ROWS
Previous Topic: REF CURSOR in SELECT Statement?- URGENT
Next Topic: select in a decode
Goto Forum:
  


Current Time: Fri Mar 29 10:26:40 CDT 2024