Re: Oracle Lite Alter Table error

In article <1027.648T354T12072181_at_rheingau.netsurf.de>,   "Lothar Armbrüster" <lothar.armbruester_at_rheingau.netsurf.de> wrote:
> 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 |
>

Good point, but I get the same result with VARCHAR2.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 11 1998 - 09:12:52 CST