Re: Newbie2 ERROR 911 and 933 open file for 7.3

From: Sean Welsh <seanw_at_order.com.au>
Date: Mon, 1 Nov 1999 12:05:07 +1100
Message-ID: <uJ5T3.172$254.3616_at_nsw.nnrp.telstra.net>


Hello,

There is nothing wrong with your SQL. Works fine on my system.

Try calling your sql script using start instead of get.

Worked for me! (see below..)

Regards,

Sean Welsh.

....

16 INSERT INTO FACULTY VALUES('209','Newton, Jane','210 Leonard,  17 Ada,MI',39000,28945,2,'MS' ,'Topology','Asso','1','Y');  18 INSERT INTO FACULTY VALUES('421','Jones, Al' ,'121 Colton,  19* Hart,MI',30000,21402,1,'PHD','Database','Asst','2','N');  20 /

        drop table faculty;
                          *

ERROR at line 1:
ORA-00911: invalid character

SQL> start faculty;

        drop table faculty
                   *

ERROR at line 1:
ORA-00942: table or view does not exist

Table created.

1 row created.

1 row created.

1 row created.

SQL> <ywure_at_interaccess.com> wrote in message news:s1pgb64aiqi70_at_corp.supernews.com...
> Student - first lab assigment
> can't execute INSERT TO VALUE instruction from stored file
>
>
> I have attached the three files - the third is the spool file
>
> It's a table from the texbook "Database Systems" by Rob and Cornel
>
> I keep getting an invalid character notice error 911
> here is the spool
>
> DROP TABLE FACULTY;
> DROP TABLE FACULTY
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
>
> SQL> get C:\ORAWIN95\PLUS33\School\Faculty_make_table.sql
> 1 create table FACULTY
> 2 (FACNUMB VARCHAR2(3) NOT NULL PRIMARY KEY,
> 3 FACNAME VARCHAR2(15) NOT NULL,
> 4 FACADDR VARCHAR2(25) NOT NULL,
> 5 SALARY NUMBER(6) NOT NULL,
> 6 EARNYTD NUMBER(6) NULL,
> 7 DEPTNUMB NUMBER(2) NOT NULL,
> 8 DEGREE VARCHAR2(12)NOT NULL,
> 9 FIELD VARCHAR2(12)NOT NULL,
> 10 CURRRANK VARCHAR2(5) NOT NULL,
> 11 PLANNUMB VARCHAR2(2) NOT NULL,
> 12* DEPCOV VARCHAR2(1) )
> SQL> RUN
> 1 create table FACULTY
> 2 (FACNUMB VARCHAR2(3) NOT NULL PRIMARY KEY,
> 3 FACNAME VARCHAR2(15) NOT NULL,
> 4 FACADDR VARCHAR2(25) NOT NULL,
> 5 SALARY NUMBER(6) NOT NULL,
> 6 EARNYTD NUMBER(6) NULL,
> 7 DEPTNUMB NUMBER(2) NOT NULL,
> 8 DEGREE VARCHAR2(12)NOT NULL,
> 9 FIELD VARCHAR2(12)NOT NULL,
> 10 CURRRANK VARCHAR2(5) NOT NULL,
> 11 PLANNUMB VARCHAR2(2) NOT NULL,
> 12* DEPCOV VARCHAR2(1) )
>
> Table created.
>
> SQL> get C:\ORAWIN95\PLUS33\School\Faculty_add_faculty.sql
> 1 INSERT INTO FACULTY VALUES('119','Martin, Barb','94 Ridge,Grant,MI'
> ,32500,25425,1,'MA' ,'Comm' ,'Asst','2','N');
> 2 INSERT INTO FACULTY VALUES('209','Newton, Jane','210 Leonard,
> Ada,MI',39000,28945,2,'MS' ,'Topology','Asso','1','Y');
> 3* INSERT INTO FACULTY VALUES('421','Jones, Al' ,'121 Colton,
> Hart,MI',30000,21402,1,'PHD','Database','Asst','2','N');
> SQL> RUN
> 1 INSERT INTO FACULTY VALUES('119','Martin, Barb','94 Ridge,Grant,MI'
> ,32500,25425,1,'MA' ,'Comm' ,'Asst','2','N');
> 2 INSERT INTO FACULTY VALUES('209','Newton, Jane','210 Leonard,
> Ada,MI',39000,28945,2,'MS' ,'Topology','Asso','1','Y');
> 3* INSERT INTO FACULTY VALUES('421','Jones, Al' ,'121 Colton,
> Hart,MI',30000,21402,1,'PHD','Database','Asst','2','N');
> INSERT INTO FACULTY VALUES('119','Martin, Barb','94 Ridge,Grant,MI'
> ,32500,25425,1,'MA' ,'Comm' ,'Asst','2','N');
>
> *
> ERROR at line 1:
> ORA-00911: invalid character
>
>
> Already have seen the instructor and tried his idea - type value error -
> corrected it.
>
> I just do not see my character error.
>
> the spaces between the ' and the comma are for legibility/proofreading. I
> get this error with/without the proofreading.
>
> Your help is much appreciated and grateful for the newsgroup.
>
>
>



>
>
>



>
>
>
Received on Mon Nov 01 1999 - 02:05:07 CET

Original text of this message