Blog Archives

ORA-01403: no data found

Message: ORA-01403: no data found Cause: No data was found from the objects. Action: There was no data from the objects which may be due to end of fetch. Explanation and Troubleshooting Tips: The most common reason for this error

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-06548: no more rows needed

Message: ORA-06548: no more rows needed Cause: The caller of a pipelined function does not need more rows to be produced by the pipelined function. Action: Catch the NO_DATA_NEEDED exception in an exception handling block. Explanation: This message is linked

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-07445: exception encountered: core dump […] […] […] […] […] […]

Message: ORA-07445: exception encountered: core dump [string] [string] [string] [string] [string] [string] Cause: An OS exception occurred which should result in the creation of a core file. This is an internal error. Action: Contact your customer support representative. See also:

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-01422: exact fetch returns more than requested number of rows

Message: ORA-01422: exact fetch returns more than requested number of rows Cause: The number specified in exact fetch is less than the rows returned. Action: Rewrite the query or change number of rows requested. Explanation and Troubleshooting Tips: An exact

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-29270: too many open HTTP requests

Message: ORA-29270: too many open HTTP requests Cause: Too many HTTP requests were opened. Action: End some HTTP requests and retry the HTTP request. Explanation and Troubleshooting Tips: There is a limit to the number of HTTP requests that can

Posted in Explained, ORA codes, Troubleshooting Tips Tagged with:

ORA-31679: Table data object … has long columns, and longs can not be loaded/unloaded using a network link

Message: ORA-31679: Table data object string has long columns, and longs can not be loaded/unloaded using a network link Cause: Table data objects that contain long columns can not be selected over a network link. Action: Export this table to

Posted in Explained, ORA codes, Troubleshooting Tips Tagged with: , , , ,

ORA-06550: line …, column …: …

Message: ORA-06550: line y, column x: message Cause: Usually a PL/SQL compilation error. Explanation and Troubleshooting Tips: ORA-06550 is a generic error that occurs when PL/SQL fails to compile due to a syntax error. The message a line number and

Posted in Explained, ORA codes, Troubleshooting Tips

ORA-39064: unable to write to the log file

Message: ORA-39064: unable to write to the log file Cause: Errors were detecting while writing to the log file. Subsequent messages will detail the problems. Action: Fix the problems outlined in the secondary messages. Troubleshooting Tips: The subsequent error messages

Posted in ORA codes, Troubleshooting Tips

ORA-20000 to ORA-20999

Message: ORA-20000: string Cause: The stored procedure ‘raise_application_error’ was called which causes this error to be generated. Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information. Explanation: The procedure

Posted in Explained, ORA codes

ORA-01034: ORACLE not available

Message: ORA-01034: ORACLE not available Cause: Oracle was not started up. Possible causes include the following: – The SGA requires more space than was allocated for it. – The operating-system variable pointing to the instance is improperly defined. Action: Refer

Posted in ORA codes, Troubleshooting Tips