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-12729: invalid character class in regular expression

Message: ORA-12729: invalid character class in regular expression Cause: An unknown character class was found in the regular expression. Action: Ensure a valid characters class is being used. Explanation and Troubleshooting Tips: Character classes match any one of a number

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-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-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-29273: HTTP request failed

Message: ORA-29273: HTTP request failed Cause: The UTL_HTTP package failed to execute the HTTP request. Action: Use get_detailed_sqlerrm to check the detailed error message. Fix the error and retry the HTTP request. Explanation and Troubleshooting Tips: There are many things

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

ORA-24247: network access denied by access control list (ACL)

Message: ORA-24247: network access denied by access control list (ACL) Cause: No access control list (ACL) has been assigned to the target host or the privilege necessary to access the target host has not been granted to the user in

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

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