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

OCI-22062: invalid input string […]

Message: OCI-22062: invalid input string [string] Cause: The text string for converting to numbers is invalid. Action: Use a valid input string as documented in OCI Programmer’s Guide. Troubleshooting Tips: Check the DataType of the parameter matches the actual type

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

ORA-22062: invalid input string […]

Message: ORA-22062: invalid input string [string] Cause: The text string for converting to numbers is invalid. Action: Use a valid input string as documented in OCI Programmer’s Guide. Troubleshooting Tips: Check the DataType of the parameter matches the actual type

Posted in Troubleshooting Tips

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