Oracle Error ORA-00900 invalid SQL statement
Cause: Normally obvious but one reason for it that is not so obvious is that you are trying to use the 'execute' command in sqldba using the V6 executable. (Using the V6 - i.e. 3.0 - version of SQL*Plus, on the other hand, will return 'unknown command'.) Action: *** Important: The notes below are for experienced users - Diagnosis: Are you getting this when trying to create a stored procedure or package? If so does PL/SQL appear in the sqldba/sqlplus/svrmgrl banner? If not, shut all instances down, log in as the Oracle user and do: Unix Pre 7.3: cd $Oracle_HOME/rdbms/lib make -f Oracle.mk procopt iOracle Unix 7.3+: cd $Oracle_HOME/rdbms/lib make -f ins_rdbms.mk procopt iOracle Oracle8 onwards should have PLSQL installed by default so the command is probably invalid |