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

Home -> Community -> Usenet -> c.d.o.server -> Newbie2 error 936 Missing Expression

Newbie2 error 936 Missing Expression

From: <ywure_at_interaccess.com>
Date: Sat, 13 Nov 99 16:37:01 GMT
Message-ID: <s2r4tgnthsq63@corp.supernews.com>


College Student needs help

I keep getting a missing expression error. I've used number and varchar and various insert combinations and can't rid the error message. Professor suggested what I am using now for product_make_table. No success.

have attached a spool file and the two sql files needed.

Thanx

Jim Quinlan

begin 644 usenet.LST
M<W1A<G0@<')O9'5C=%]M86ME7W1A8FQE+G-Q;#L-"E-13#X_at_0U)%051%(%1! M0DQ%(%!23T150U0-"B`@,B`@*%!?0T]$10D@("`@(%9!4D-(05(R*#$P*2`@

M("!.3U0_at_3E5,3`D@("`@(%!224U!4ED_at_2T59+`T*("`S("!07T1%4T-225!4
M(`D@("`@(%9!4D-(05(R*#,U*2`@("!.3U0_at_3E5,3"P-"B`@-"`@4%])3D1!
M5$4)"2`@("`@1$%410D)("`@("!.3U0_at_3E5,3"P-"B`@-2`@4%]/3DA!3D0)
M"2`@("`@3E5-0D52*#,I+`T*("`V("!07TU)3_at_D)("`@("!.54U"15(H,RD)
M"2`@("`@3D]4($Y53$PL#0H@(#<@(%!?4%))0T4)("`@("!.54U"15(H-BPR
M*0D@("`@($Y/5"!.54Q,+`T*("`X("!07T1)4T-/54Y4(`D@("`@($Y534)%
M4B_at_T+#(I"2`@("`@3D]4($Y53$PL#0H@(#D@(%9?0T]$10D@("`@(%9!4D-( M05(R*#4I("`@("!.54Q,#0H@,3`@("D-"B`Q,2`@+PT*4U%,/B!S=&%R="!P M<F]D=6-T7V%D9%]P<F]D=6-T+G-Q;#L-"E-13#X@<V5T(&1E9FEN92!O9F8- M"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H)S$Q4452+S,Q)RP@
M("=0;W=E<B!086EN=&5R+"`Q-7!S:2P@,RUN;WIZ;&4G+`D)("`@("`G,#(M
M1&5C+3DV)RP@("`@."P@("`@("`U+"`@("`@(#$P.2XY.2P)("`@("`P+C`P
M+"`@(#(U.3DU*3L-"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H
M)S$S+5$R+U`R)RP@("<W+C(U+6EN('!W<BX@<V%W(&)L861E)RP)"0D@("`@
M("<Q,BU.;W8M.38G+"`@("`S,BP@("`@(#$U+"`@("`@,30N.3DL"2`@("`@ M,"XP-2P@("`R,3,T-"D[#0I344P^($E.4T525"!)3E1/(%!23T150U0_at_5D%, M5453*"<Q-"U1,2U,,R<L("`G.2XP,"UI;B!P=W(N('-A=R!B;&%D92<L"0D)
M("`@("`G,3(M3F]V+3DV)RP@("`@,3_at_L("`@("`Q,BP@("`@(#$W+C0Y+`D@
M("`@(#`N,#`L("`@,C$S-#0I.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4
M(%9!3%5%4R_at_G,34T-BU143(G+"`@)TAR9"X_at_8VQO=&@L(#$O-"UI;BP@,E_at_U
M,"<L"0D@("`@("<Q-"U!=6<M.38G+"`@("`Q-2P@("`@(#@L("`@("`@,SDN
M.34L"2`@("`@,"XP,"P@("`R,S$Q.2D[#0I344P^($E.4T525"!)3E1/(%!2
M3T150U0_at_5D%,5453*"<Q-34X+5%7,2<L("`G2')D+B!C;&]T:"P@,2\R+6EN
M+"`S6#4P)RP)"2`@("`@)S$T+4%U9RTY-B<L("`@(#(S+"`@("`@-2P@("`@
M("`T,RXY.2P)("`@("`P+C`P+"`@(#(S,3$Y*3L-"E-13#X_at_24Y315)4($E.
M5$\@4%)/1%5#5"!604Q515,H)S(R,S(O4519)RP@("=")D0@:FEG<V%W+"`Q
M,BUI;BP_at_8FQA9&4G+`D)("`@("`G,CDM3V-T+3DV)RP@("`@."P@("`@("`U
M+"`@("`@(#$P.2XY,BP)("`@("`P+C`U+"`@(#(T,C_at_X*3L-"E-13#X_at_24Y3
M15)4($E.5$\@4%)/1%5#5"!604Q515,H)S(R,S(O45=%)RP@("=")D0@:FEG
M<V%W+"`X+6EN+"!B;&%D92<L(`D)("`@("`G,#DM4V5P+3DV)RP@("`@-BP@
M("`@("`U+"`@("`@(#DY+C_at_W+`D@("`@(#`N,#4L("`@,C0R.#@I.PT*4U%, M/B!)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G,C(S."]14$0G+"`@)T(F
M1"!C;W)D;&5S<R!D<FEL;"P@,2\R:6XG+`D)("`@("`G,3DM3V-T+3DV)RP@
M("`@,3(L("`@("`U+"`@("`@(#,X+CDU+`D@("`@(#`N,#4L("`@,C4U.34I
M.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G,C,Q,#DM2$(G
M+"`@)T-L87<@:&%M;65R)RP)"0D)("`@("`G,3DM3F]V+3DV)RP@("`@,C,L
M("`@("`Q,"P@("`@(#DN.34L"0D@("`@(#`N,3`L("`@,C$R,C4I.PT*4U%, M/B!)3E-%4E0_at_24Y43R!04D]$54-4("A07T-/1$4L4%]$15-#4DE05"Q07TE. M1$%412Q07T].2$%.1"Q07TU)3BQ07U!224-%+%!?1$E30T]53E0I(%9!3%5% M4R_at_G,C,Q,30M04$G+"`@("=3;&5D9V4@:&%M;65R+"`Q,B!L8BXG+`D)"2`@
M("`@)S`Q+41E8RTY-B<L("`@(#@L("`@("`@-2P@("`@("`Q-"XT,"P)("`@
M("`P+C`U+"`I(#L-"DE.4T525"!)3E1/(%!23T150U0@*%!?0T]$12Q07T1%
M4T-225!4+%!?24Y$051%+%!?3TY(04Y$+%!?34E.+%!?4%))0T4L4%]$25-#
M3U5.5"D_at_5D%,5453*"<R,S$Q-"U!02<L"2=3;&5D9V4@:&%M;65R+"`Q,B!L
M8BXG+`D)"2<P,2U$96,M.38G+`DX+`DU+`DQ-"XT,"P)"3`N,#4L("D)#0H@
M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@(`D@("`@("`@("`@("`@("`@("`@("`@("`)"0D@("`@("`@
M("`@("`)("`)("`)("`@("`@"0D@("`@("`J#0I%4E)/4B!A="!L:6YE(#$Z M(`T*3U)!+3`P.3,V.B!M:7-S:6YG(&5X<')E<W-I;VX@#0H-"@T*4U%,/B!) M3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G-30W-S@M,E0G+"`@)U)A="UT M86EL(&9I;&4L(#$O."UI;BP_at_9FEN92<L"2`@("`@)S$T+4IU;BTY-B<L("`@ M(#0S+"`@("`@,C`L("`@("`T+CDY+`D)("`@("`P+C`P+"`@(#(Q,S0T*3L- M"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H)S_at_Y+5=212U1)RP@
M("=(:6-U="!C:&%I;B!S87<L(#$V(&EN)RP)"0D@("`@("<P-BU*=6PM.38G
M+"`@("`Q,2P@("`@(#4L("`@("`@,C4V+CDY+`D@("`@(#`N,#`L("`@,C0R
M.#@I.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4("`H4%]#3T1%+%!?1$53
M0U))4%0L4%])3D1!5$4L4%]/3DA!3D0L4%]-24XL4%]04DE#12Q07T1)4T-/
M54Y4*2!604Q515,H)U!60S(S1%)4)RP@("=05D,@<&EP92P@,RXU+6EN+B`X
M+69T)RP)"0D@("`@("<Q.2U$96,M.38G+"`@("`Q.#@L("`@(#<U+"`@("`@
M-2XX-RP)"2`@("`@,"XP,"P@*2`[#0I)3E-%4E0_at_24Y43R!04D]$54-4("`H
M4%]#3T1%+%!?1$530U))4%0L4%])3D1!5$4L4%]/3DA!3D0L4%]-24XL4%]0 M4DE#12Q07T1)4T-/54Y4*2!604Q515,H)U!60S(S1%)4)RP))U!60R!P:7!E
M+"`S+C4M:6XN(#@M9G0G+`D)"2<Q.2U$96,M.38G+`DQ.#@L"3<U+`DU+C_at_W
M+`D)"3`N,#`L("D)#0H@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
M("`@("`@("`@("`@("`@("`@("`@("`@("`)("`@("`@("`@("`@("`@("`@
M("`@("`@(`D)"2`@("`@("`@("`@(`D@("`@"2`@(`D@("`@(`D)"2`@("`@ M("H-"D524D]2(&%T(&QI;F4@,3H@#0I/4D$M,#`Y,S8Z(&UI<W-I;F<@97AP M<F5S<VEO;B`-"@T*#0I344P^($E.4T525"!)3E1/(%!23T150U0_at_5D%,5453
M*"=332TQ.#(W-R<L("`G,2XR-2UI;B!M971A;"!S8W)E=RP@,C4G+"`)"2`@
M("`@)S(X+4YO=BTY-B<L("`@(#$W,BP@("`@-S4L("`@("`V+CDY+`D)("`@
M("`P+C`P+"`@(#(Q,C(U*3L-"E-13#X_at_24Y315)4($E.5$\@4%)/1%5#5"!6
M04Q515,H)U-7+3(S,3$V)RP@("<R+C4M:6X@=V0N('-C<F5W+"`U,"<L"0D)
M("`@("`G,#DM4V5P+3DV)RP@("`@,C,W+"`@("`Q,#`L("`@(#@N-#4L"0D@
M("`@(#`N,#`L("`@,C$R,S$I.PT*4U%,/B!)3E-%4E0_at_24Y43R!04D]$54-4
M(%9!3%5%4R_at_G5U(S+U14,R`G+"`@)U-T965L(&UA='1I;F<L-%_at_X6#$O-B(L
M-2(@;65S:"<L"0D@("`@("<Q-BU.;W8M.38G+"`@("`Q."P@("`@(#4L("`@ F("`@,3$Y+CDU+`D@("`@(#`N,3`L("`@,C4U.34I.PT*4U%,/B!I
`

end

begin 644 product_make_table.sql

M0U)%051%(%1!0DQ%(%!23T150U0-"BA07T-/1$4)"59!4D-(05(R*#$P*0E.
M3U0_at_3E5,3`E04DE-05)9($M%62P-"E!?1$530U))4%0)"59!4D-(05(R*#,U
M*0E.3U0_at_3E5,3"P-"E!?24Y$051%"0E$051%"0D)3D]4($Y53$PL#0I07T].
M2$%.1`D)3E5-0D52*#,I+`T*4%]-24X)"0E.54U"15(H,RD)"4Y/5"!.54Q, M+`T*4%]04DE#10D)3E5-0D52*#8L,BD)"4Y/5"!.54Q,+`T*4%]$25-#3U5. M5`D)3E5-0D52*#0L,BD)"4Y/5"!.54Q,+`T*5E]#3T1%"0E605)#2$%2,B_at_U /*2`)3E5,3`T**0T*+PT*
`

end

begin 644 product_add_product.sql
M<V5T(&1E9FEN92!O9F8-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<Q M,5%%4B\S,2<L"2=0;W=E<B!086EN=&5R+"`Q-7!S:2P@,RUN;WIZ;&4G+`D) M)S`R+41E8RTY-B<L"3_at_L"34L"3$P.2XY.2P)"3`N,#`L"3(U.3DU*3L-"DE. M4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<Q,RU1,B]0,B<L"2<W+C(U+6EN M('!W<BX@<V%W(&)L861E)RP)"0DG,3(M3F]V+3DV)RP),S(L"3$U+`DQ-"XY M.2P)"3`N,#4L"3(Q,S0T*3L-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453 M*"<Q-"U1,2U,,R<L"2<Y+C`P+6EN('!W<BX@<V%W(&)L861E)RP)"0DG,3(M M3F]V+3DV)RP),3_at_L"3$R+`DQ-RXT.2P)"3`N,#`L"3(Q,S0T*3L-"DE.4T52 M5"!)3E1/(%!23T150U0_at_5D%,5453*"<Q-30V+5%1,B<L"2=(<F0N(&-L;W1H M+"`Q+S0M:6XL(#)8-3`G+`D)"2<Q-"U!=6<M.38G+`DQ-2P)."P),SDN.34L M"0DP+C`P+`DR,S$Q.2D[#0I)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G

M,34U."U15S$G+`DG2')D+B!C;&]T:"P@,2\R+6EN+"`S6#4P)RP)"0DG,30M
M075G+3DV)RP),C,L"34L"30S+CDY+`D),"XP,"P),C,Q,3DI.PT*24Y315)4
M($E.5$\@4%)/1%5#5"!604Q515,H)S(R,S(O4519)RP))T(F1"!J:6=S87<L
M(#$R+6EN+"!B;&%D92<L"0D))S(Y+4]C="TY-B<L"3_at_L"34L"3$P.2XY,BP)
M"3`N,#4L"3(T,C_at_X*3L-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<R
M,C,R+U%712<L"2=")D0@:FEG<V%W+"`X+6EN+"!B;&%D92<L"0D))S`Y+5-E
M<"TY-B<L"38L"34L"3DY+C_at_W+`D),"XP-2P),C0R.#@I.PT*24Y315)4($E.
M5$\@4%)/1%5#5"!604Q515,H)S(R,S_at_O45!$)RP))T(F1"!C;W)D;&5S<R!D M<FEL;"P@,2\R:6XG+`D)"2<Q.2U/8W0M.38G+`DQ,BP)-2P),S_at_N.34L"0DP M+C`U+`DR-34Y-2D[#0I)3E-%4E0_at_24Y43R!04D]$54-4(%9!3%5%4R_at_G,C,Q M,#DM2$(G+`DG0VQA=R!H86UM97(G+`D)"0D))S$Y+4YO=BTY-B<L"3(S+`DQ M,"P).2XY-2P)"0DP+C$P+`DR,3(R-2D[#0I)3E-%4E0_at_24Y43R!04D]$54-4 M("A07T-/1$4L4%]$15-#4DE05"Q07TE.1$%412Q07T].2$%.1"Q07TU)3BQ0 M7U!224-%+%!?1$E30T]53E0I(%9!3%5%4R_at_G,C,Q,30M04$G+`DG4VQE9&=E M(&AA;6UE<BP@,3(@;&(N)RP)"0DG,#$M1&5C+3DV)RP)."P)-2P),30N-#`L M"0DP+C`U+"`I"3L-"DE.4T525"!)3E1/(%!23T150U0_at_5D%,5453*"<U-#<W M."TR5"<L"2=2870M=&%I;"!F:6QE+"`Q+S_at_M:6XL(&9I;F4G+`D))S$T+4IU M;BTY-B<L"30S+`DR,"P)-"XY.2P)"0DP+C`P+`DR,3,T-"D[#0I)3E-%4E0@ M24Y43R!04D]$54-4(%9!3%5%4R_at_G.#DM5U)%+5$G+`DG2&EC=70_at_8VAA:6X@ M<V%W+"`Q-B!I;B<L"0D))S`V+4IU;"TY-B<L"3$Q+`DU+`DR-38N.3DL"0DP M+C`P+`DR-#(X."D[#0I)3E-%4E0_at_24Y43R!04D]$54-4("`H4%]#3T1%+%!? M1$530U))4%0L4%])3D1!5$4L4%]/3DA!3D0L4%]-24XL4%]04DE#12Q07T1)
M4T-/54Y4*2!604Q515,H)U!60S(S1%)4)RP))U!60R!P:7!E+"`S+C4M:6XN
M(#@M9G0G+`D)"2<Q.2U$96,M.38G+`DQ.#@L"3<U+`DU+C_at_W+`D)"3`N,#`L
M("D).PT*24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H)U--+3$X,C<W)RP)
M)S$N,C4M:6X@;65T86P@<V-R97<L(#(U)RP)"0DG,C_at_M3F]V+3DV)RP),3<R
M+`DW-2P)-BXY.2P)"0DP+C`P+`DR,3(R-2D[#0I)3E-%4E0_at_24Y43R!04D]$ M54-4(%9!3%5%4R_at_G4U<M,C,Q,38G+`DG,BXU+6EN('=D+B!S8W)E=RP_at_-3`G
M+`D)"0DG,#DM4V5P+3DV)RP),C,W+`DQ,#`L"3_at_N-#4L"0D),"XP,"P),C$R
M,S$I.PT*24Y315)4($E.5$\@4%)/1%5#5"!604Q515,H)U=2,R]45#,@)RP)
M)U-T965L(&UA='1I;F<L-%_at_X6#$O-B(L-2(@;65S:"<L"0DG,38M3F]V+3DV
@)RP),3_at_L"34L"3$Q.2XY-2P)"3`N,3`L"3(U-3DU*3LL
`

end Received on Sat Nov 13 1999 - 10:37:01 CST

Original text of this message

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