Re: How to install the procedural option ?

From: Gareth Gale <gareth.gale_at_hp.com>
Date: Thu, 10 Nov 2005 14:18:28 +0000
Message-ID: <dkvl16$af1$1@malatesta.hpl.hp.com>

Running Enerprise Edition. Here's the SQL statment :-

load data infile 'C:\data\mydata.csv' into table db."table" fields terminated by "," optionally enclosed by '"';

DA Morgan wrote:

> Gareth Gale wrote:
> 

>> 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

> 
> 
> It would be very helpful to see the SQL statement: Essential actually.

Received on Thu Nov 10 2005 - 08:18:28 CST