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-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

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-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-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

ORA-06512: at … line …

Message: ORA-06512: at string line string Cause: Backtrace message as the stack is unwound by unhandled exceptions. Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application

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

PLS-00640: a pipelined function cannot be called from PL/SQL context

Message: PLS-00640: a pipelined function cannot be called from PL/SQL context Cause: A pipelined function was invoked from a PL/SQL expression. Action: Use the pipelined function in the FROM clause of a SQL query. Explanation and Troubleshooting Tips: Pipelined table

Posted in Explained, PLS codes, Troubleshooting Tips