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

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

PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

Message: PLS-00653: aggregate/table functions are not allowed in PL/SQL scope Cause: User tried to use a table/aggregate function in PL/SQL scope. Action: Do not use table/aggregate function in PL/SQL scope. Explanation and Troubleshooting Tips: Table functions and aggregate functions can

Posted in Explained, PLS codes, Troubleshooting Tips

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