Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Please take a look at few lines of code

Please take a look at few lines of code

From: christoph erdt <cherdt_at_cwix.com>
Date: Tue, 29 Dec 1998 07:05:00 GMT
Message-ID: <36887908.18699177@news.halcyon.com>

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 - 01:05:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US