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

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:

TNS-03502: Insufficient arguments. Usage: tnsping <address> [<count>]

Message: TNS-03502: Insufficient arguments. Usage: tnsping address [count] Cause: Required command-line arguments are missing. Action: Re-enter the command using the correct arguments. Explanation and Troubleshooting Tips: The tnsping commandline utility accepts two parameters on the command line. The first, address,

Posted in Explained, Troubleshooting Tips

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