|Subject:||How to install the procedural option ?|
|Posted by:||Gareth Gale (gareth.ga…@hp.com)|
|Date:||Thu, 10 Nov 2005|
I'm running Oracle 10g on Linux. I'm trying to bulk load the database
but am getting :-
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.
How do I check for and install the procedural option ?