Newbie2 ERROR 911 and 933 open file for 7.3
Date: Sun, 31 Oct 99 23:23:25 GMT
Message-ID: <s1pgb64aiqi70_at_corp.supernews.com>
Student - first lab assigment
[Quoted] 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.
begin 644 Faculty_make_table.sql
M8W)E871E('1A8FQE($9!0U5,5%D-"BA&04-.54U"(%9!4D-(05(R*#,I($Y/
M5"!.54Q,(%!224U!4ED_at_2T59+`T*1D%#3D%-12!605)#2$%2,B_at_Q-2D@3D]4
M($Y53$PL#0I&04-!1$12(%9!4D-(05(R*#(U*2!.3U0_at_3E5,3"P-"E-!3$%2
M62!.54U"15(H-BD_at_("`@($Y/5"!.54Q,+`T*14%23EE41"`_at_3E5-0D52*#8I
M("`_at_("`@($Y53$PL#0I$15!43E5-0B!.54U"15(H,BD@("!.3U0_at_3E5,3"PM"
D1%1U)%12`_at_(%9!4D-(05(R*#$R*4Y/5"!.54Q,+`T*1DE%3$0@("`_at_5D%2
M0TA!4C(H,3(I3D]4($Y53$PL#0I#55)24D%.2R!605)#2$%2,B_at_U*2!.3U0@
M3E5,3"P-"E!,04Y.54U"(%9!4D-(05(R*#(I($Y/5"!.54Q,+`T*1$500T]6
5("`_at_5D%20TA!4C(H,2D@*0T*+PT*
`
end
begin 644 Faculty_add_faculty.sql
M24Y315)4($E.5$\_at_1D%#54Q462!604Q515,H)S$Q.2<L)TUA<G1I;BP_at_0F%R
M8B<L)SDT(%)I9&=E+$=R86YT+$U))R`_at_+#,R-3`P+#(U-#(U+#$L)TU!)R`L
M)T-O;6TG("`_at_("PG07-S="<L)S(G+"=.)RD[#0I)3E-%4E0_at_24Y43R!&04-5
M3%19(%9!3%5%4R_at_G,C`Y)RPG3F5W=&]N+"!*86YE)RPG,C$P($QE;VYA<F0L
M($%D82Q-22<L,SDP,#`L,C_at_Y-#4L,BPG35,G("PG5&]P;VQO9WDG+"=!<W-O
M)RPG,2<L)UDG*3L-"DE.4T525"!)3E1/($9!0U5,5%D_at_5D%,5453*"<T,C$G
M+"=*;VYE<RP_at_06PG("`@+"<Q,C$_at_0V]L=&]N+"!(87)T+$U))RPS,#`P,"PR
M,30P,BPQ+"=02$0G+"=$871A8F%S92<L)T%S<W0G+"<R)RPG3B<I.PT*+PT*
`
end
begin 644 Email.lst
M1%)/4"!404),12!&04-53%19.PT*1%)/4"!404),12!&04-53%19#0H_at_("`@
M("`_at_("`@("H-"D524D]2(&%T(&QI;F4@,3H@#0I/4D$M,#`Y-#(Z('1A8FQE
M(&]R('9I97<_at_9&]E<R!N;W0_at_97AI<W0@#0H-"@T*4U%,/B!G970_at_0SI<3U)!
M5TE..35<4$Q54S,S7%-C:&]O;%Q&86-U;'1Y7VUA:V5?=&%B;&4N<W%L#0H_at_
M(#$_at_(&-R96%T92!T86)L92!&04-53%19#0H@(#(@("A&04-.54U"(%9!4D-(
M05(R*#,I($Y/5"!.54Q,(%!224U!4ED_at_2T59+`T*("`S("!&04-.04U%(%9!
M4D-(05(R*#$U*2!.3U0_at_3E5,3"P-"B`_at_-"`_at_1D%#041$4B!605)#2$%2,B_at_R
M-2D_at_3D]4($Y53$PL#0H@(#4@(%-!3$%262!.54U"15(H-BD@("`@($Y/5"!.
M54Q,+`T*("`V("!%05).651$("!.54U"15(H-BD_at_("`@("`_at_3E5,3"P-"B`@
M-R`_at_1$505$Y534(@3E5-0D52*#(I("`_at_3D]4($Y53$PL#0H@(#@@($1%1U)%
M12`_at_(%9!4D-(05(R*#$R*4Y/5"!.54Q,+`T*("`Y("!&245,1"`@("!605)#
M2$%2,B_at_Q,BE.3U0_at_3E5,3"P-"B`Q,"`_at_0U524E)!3DL_at_5D%20TA!4C(H-2D@
M3D]4($Y53$PL#0H_at_,3$@(%!,04Y.54U"(%9!4D-(05(R*#(I($Y/5"!.54Q,
M+`T*(#$R*B!$15!#3U8_at_("!605)#2$%2,B_at_Q*2`I#0I344P^(%)53_at_T*("`Q
M("!C<F5A=&4_at_=&%B;&4_at_1D%#54Q460T*("`R("`H1D%#3E5-0B!605)#2$%2
M,B_at_S*2!.3U0_at_3E5,3"!04DE-05)9($M%62P-"B`@,R`_at_1D%#3D%-12!605)#
M2$%2,B_at_Q-2D_at_3D]4($Y53$PL#0H@(#0@($9!0T%$1%(@5D%20TA!4C(H,C4I
M($Y/5"!.54Q,+`T*("`U("!304Q!4ED_at_3E5-0D52*#8I("`@("!.3U0_at_3E5,
M3"P-"B`_at_-B`_at_14%23EE41"`_at_3E5-0D52*#8I("`@("`@($Y53$PL#0H@(#<@
M($1%4%1.54U"($Y534)%4B_at_R*2`@($Y/5"!.54Q,+`T*("`X("!$14=2144@
M("!605)#2$%2,B_at_Q,BE.3U0_at_3E5,3"P-"B`@.2`_at_1DE%3$0@("`_at_5D%20TA!
M4C(H,3(I3D]4($Y53$PL#0H_at_,3`@($-54E)204Y+(%9!4D-(05(R*#4I($Y/
M5"!.54Q,+`T*(#$Q("!03$%.3E5-0B!605)#2$%2,B_at_R*2!.3U0_at_3E5,3"PM"
B`Q,BH_at_1$500T]6("`_at_5D%20TA!4C(H,2D@*0T*#0I486)L92!C<F5A=&5D
M+_at_T*#0I344P^(&=E="!#.EQ/4D%724XY-5Q03%53,S-<4V-H;V]L7$9A8W5L
M='E?861D7V9A8W5L='DN<W%L#0H_at_(#$@($E.4T525"!)3E1/($9!0U5,5%D@
M5D%,5453*"<Q,3DG+"=-87)T:6XL($)A<F(G+"<Y-"!2:61G92Q'<F%N="QM
22<_at_("PS,C4P,"PR-30R-2PQ+"=-02<@+"=#;VUM)R`@("`L)T%S<W0G+"<R
M)RPG3B<I.PT*("`R("!)3E-%4E0_at_24Y43R!&04-53%19(%9!3%5%4R_at_G,C`Y
M)RPG3F5W=&]N+"!*86YE)RPG,C$P($QE;VYA<F0L($%D82Q-22<L,SDP,#`L
M,C_at_Y-#4L,BPG35,G("PG5&]P;VQO9WDG+"=!<W-O)RPG,2<L)UDG*3L-"B`@
M,RH_at_24Y315)4($E.5$\@1D%#54Q462!604Q515,H)S0R,2<L)TIO;F5S+"!!
M;"<_at_("`L)S$R,2!#;VQT;VXL($AA<G0L34DG+#,P,#`P+#(Q-#`R+#$L)U!(
M1"<L)T1A=&%B87-E)RPG07-S="<L)S(G+"=.)RD[#0I344P^(%)53_at_T*("`Q
M("!)3E-%4E0_at_24Y43R!&04-53%19(%9!3%5%4R_at_G,3$Y)RPG36%R=&EN+"!"
M87)B)RPG.30_at_4FED9V4L1W)A;G0L34DG("`L,S(U,#`L,C4T,C4L,2PG34$G
M("PG0V]M;2<_at_("`@+"=!<W-T)RPG,B<L)TXG*3L-"B`@,B`_at_24Y315)4($E.
M5$\_at_1D%#54Q462!604Q515,H)S(P.2<L)TYE=W1O;BP_at_2F%N92<L)S(Q,"!,
M96]N87)D+"!!9&$L34DG+#,Y,#`P+#(X.30U+#(L)TU3)R`L)U1O<&]L;V=Y
M)RPG07-S;R<L)S$G+"=9)RD[#0H_at_(#,J($E.4T525"!)3E1/($9!0U5,5%D@
M5D%,5453*"<T,C$G+"=*;VYE<RP_at_06PG("`@+"<Q,C$_at_0V]L=&]N+"!(87)T
M+$U))RPS,#`P,"PR,30P,BPQ+"=02$0G+"=$871A8F%S92<L)T%S<W0G+"<R
M)RPG3B<I.PT*24Y315)4($E.5$\_at_1D%#54Q462!604Q515,H)S$Q.2<L)TUA
M<G1I;BP_at_0F%R8B<L)SDT(%)I9&=E+$=R86YT+$U))R`@+#,R-3`P+#(U-#(U
M+#$L)TU!)R`L)T-O;6TG("`_at_("PG07-S="<L)S(G+"=.)RD[#0H@("`@("`@
M("`_at_("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`_at_("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`_at_("`@("`@("`@("`@("`@("H-"D524D]2(&%T(&QI;F4@,3H@#0I/4D$M
D,#`Y,3$Z(&EN=F%L:60_at_8VAA<F%C=&5R(`T*#0H-"E-13#X@
`
end Received on Mon Nov 01 1999 - 00:23:25 CET