SQL*Plus Win error...

From: <siglerg_at_my-deja.com>
Date: Fri, 09 Jul 1999 22:59:14 GMT
Message-ID: <7m5urs$nho$1_at_nnrp1.deja.com>

[Quoted] 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 Sat Jul 10 1999 - 00:59:14 CEST