Re: Please take a look at few lines of code

Hi Christoph

When using the standard editor for editing in SQL*Plus never (read : never) end your statement with a ";"
Just leave it out of notepad.

Hth,

Miguel

christoph erdt wrote:

> Please take a look at this few lines - I cannot find out why I get
> message:
>
> ERROR at line 2:ORA-00911: invalid character
>
> when I use notepad to edit code and it happens each time.
> It works OK after I type it in without making corrections in notepad.
> I make many mistakes and could use a working editor.
> Tks......
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Mon Dec 28 22:50:24 1998
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> SQL> define_editor = d:\winnt\notepad
> SQL> drop table chris;
>
> Table dropped.
>
> SQL> create table chris (
> 2
> SQL>
> SQL> edit
> Wrote file afiedt.buf
>
> 1 create table chris (
> 2* salmon varchar2(20) );
> SQL> /
> salmon varchar2(20) );
> *
> ERROR at line 2:
> ORA-00911: invalid character
>
> SQL> create table chris (
> 2 salmon varchar2(20) );
>
> Table created.
Received on Tue Dec 29 1998 - 02:21:44 CST