Re: Oracle Lite Alter Table error

On 10-Dez-98 00:44:41 dmeany wrote:

>Has anyone else had trouble with ALTER TABLE on Oracle Lite? I don't
>think it's my typing because I get the same syntax error in Oracle 8
>Navigator when trying to modify a table using the designer. Here's the
>example:

>Oracle Open Client Adapter for ODBC 6.0.5.1.0
>Oracle Lite ORDBMS 3.5.0.1.0

SQL>> create table test1 ( a char(1) );

>Table created.

SQL>> alter table test1 modify ( a varchar(10) );
>alter table test1 modify ( a varchar(10) )
>*
>ERROR at line 1:
>OCA-30021: error preparing/executing SQL statement
>[POL-5228] syntax error

I'm just guessing but try this:

alter table test1 modify ( a varchar2(10) );

The standard data type for variable strings in Oracle is VARCHAR2 *not* VARCHAR. Normally, VARCHAR is replaced by VARCHAR2 if it occurs. Maybe Oracle changed this for OracleLite.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |