http://orafind.com Complete Source for Oracle Error Code Ora-, Pl/Sql Tips and Tricks and Oracle Error Message Description Tue, 15 Apr 2008 06:14:19 +0000 http://backend.userland.com/rss092 en For you Oracle Developer, Oracle Programmer and Oracle Professional, should be familiar with this Oracle Error Code Ora-XXXXX and Oracle Error Messages. This Oracle Error Code and Oracle error messages basically generated by Oracle database. The prefix "ORA-" shows that the message was generated by Oracle products. Every oracle error ... http://orafind.com/oracle-error/what-is-oracle-error-code-and-oracle-error-message/ Cause : This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetching from a ... http://orafind.com/oracle-error/ora-01002-fetch-out-of-sequence/ Cause : Either a host language program call specified an invalid cursor or the values of the AREASIZE and MAXOPENCURSORS options in the precompiler command were too small. All cursors must be opened using the OOPEN call before being referenced in any of the following calls: SQL, DESCRIBE, NAME, DEFINE, ... http://orafind.com/oracle-error/ora-01001-invalid-cursor/ Cause : A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. Action : Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.Share This http://orafind.com/oracle-error/ora-01000-maximum-open-cursors-exceeded/ Cause : In a CREATE VIEW statement, the view name was missing or invalid. Action : Enter a valid view name following CREATE VIEW. Valid view names must begin with a letter, consist of only alphanumeric characters and the special characters $, _, and #, be less than or equal to ... http://orafind.com/oracle-error/ora-00999-invalid-view-name/ Cause : An expression or function was used in a CREATE VIEW statement, but no corresponding column name was specified. When expressions or functions are used in a view, all column names for the view must be explicitly specified in the CREATE VIEW statement. Action : Enter a column name for ... http://orafind.com/oracle-error/ora-00998-must-name-this-expression-with-a-column-alias/ Cause : A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause. Action : Remove the LONG value from the function or clause.Share This http://orafind.com/oracle-error/ora-00997-illegal-use-of-long-datatype/ Cause : A single bar (|) was interpreted as an attempt to specify concatenation, but the concatenation operator is a double bar (||). Action : Enter a double bar (||) for concatenation or remove the single bar (|) if concatenation was not intended.Share This http://orafind.com/oracle-error/ora-00996-the-concatenate-operator-is-not/ Cause : In a CREATE or DROP SYNONYM statement, the synonym name was either missing or invalid. Action : Check syntax and spelling. A valid synonym name must be specified immediately following the keyword SYNONYM in both statements. Valid synonym names must begin with a letter, consist of alphanumeric characters and the ... http://orafind.com/oracle-error/ora-00995-missing-or-invalid-synonym-identifier/ Cause : The keywords WITH GRANT were specified at the end of a GRANT statement without the keyword OPTION. Action : Change the keywords WITH GRANT to the keywords WITH GRANT OPTION. Then retry the statement.Share This http://orafind.com/oracle-error/ora-00994-missing-option-keyword/