How to install the procedural option ?

From: Gareth Gale <gareth.gale_at_hp.com>
Date: Thu, 10 Nov 2005 13:01:53 +0000
Message-ID: <dkvghj$9ag$1@malatesta.hpl.hp.com>

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 ?

Thanks Received on Thu Nov 10 2005 - 07:01:53 CST