Oracle Database Administration, Performance Tuning, Backup Recovery
ORA-00904 invalid column name

ORA-00904 invalid column name

 
ORA-00900 invalid SQL statement
ORA-00900 invalid SQL statement

Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.

Action: Correct the syntax or install the Procedural Option.
 
DBMS OUTPUT Oracle Package

DBMS_OUTPUT oracle package enables you to send output messages from various other PL/SQL program units like stored procedures, packages, triggers etc.  DBMS_OUTPUT is primarily used for displaying messages or debug information  from a PL/SQL Program. The  procedures contained in this package are DISABLE, ENABLE, PUT, PUT_LINE, GET_LINE, GET_LINES and NEW_LINE.

 
ORA-12560 : TNS:protocol adapter error occurred

ORA-12560 Oracle error indicates a high level error that may have happened in the oracle sqlnet or net8 transport layer. The actual error should be identified based on the other messages that oracle has displayed along with the ORA-12560 error message

 
ORA-06502 PL/SQL: numeric or value error

ORA-6502 mostly occurs during execution of code in an oracle database due to a bug in the SQL or PL/SQL code. The primary reason this oracle error occurs is when you try to assign a value to a numeric variable but the value is larger than the variable can handle.  ORA-06502 oracle error also occurs if you are trying to assign a non-numeric value to a numeric variable

 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Results 46 - 50 of 69
[ Back ]

Popular Articles

Latest Articles

Favourite Links