Re: SQL*Plus Win error...

Its only an idea but....
Try ending all your sql statements witha semi-colon ';'. When pasting into sqlplus, i think you may be able to get away with not putting semi colons in but when doing it froma script, you need it.

M

siglerg_at_my-deja.com wrote in message <7m5urs$nho$1_at_nnrp1.deja.com>...
>This is good...
>
>I have a script file that I cannot open and run in SQL*Plus for Windows
>successfully using the menu selections, but if I open the file in
>notepad or wordpad and cut and paste the text, it executes
>successfully. It also works using SQL*Plus on my Unix host.
>
>Error text is:
>
>>create view wbc as
>>*
>>ERROR at line 10:
>>ORA-00936: missing expression
>
>with no views created...
>
>Here's the script:
>
>create view lymph as
>select to_number (pt) ptno,
> actevent aeve,
> cpevent visit,
> lparm test,
> lvalue result
>from CP046$current.normlab2
>where lparm = 'LYMPH'
>/
>create view wbc as
>select to_number(pt) ptn,
> actevent eve,
> cpevent vst,
> lparm tst,
> lvalue rslt
>from CP046$current.normlab2
>where lparm = 'WBC' and (lvalue <> 'ND' and lvalue is not null)
>/
>create view NEUT as
>select to_number(pt) ptnum,
> actevent aevent,
> cpevent cpvisit,
> lparm testname,
> lvalue results
>from CP046$current.normlab2
>where lparm = 'NEUT' and (lvalue not in ('ND') and lvalue is not null)
>/
>create view lw as
>select lymph.ptno, wbc.ptn, lymph.test, wbc.tst,
> to_number(lymph.result) rst, to_number(wbc.rslt) rt,
> lymph.aeve, wbc.eve, lymph.visit, wbc.vst
>from lymph, wbc
>where lymph.ptno = wbc.ptn and
> lymph.visit = wbc.vst and
> lymph.test = wbc.tst
>/
>drop view lymph
>/
>drop view wbc
>/
>drop view lw
>/
>drop view neut
>/
>
>Behavior is the same running SQL*Plus v. 3.3.3.0.0 on Win NT SP5, or
>Windows 95 "b" against Oracle 7.3.3.6 on Solaris. Only special
>characters are the CR/LF between lines and TABs. Anyone got any ideas
>why reading it in thru a file fails while cutting and pasting works?
>
>TIA,
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Jul 12 1999 - 10:27:04 CEST