OraFAQ Forum: Unix » help ! why can't i use @ to run a script file in HP-UX 11i (b23)

Home » Infrastructure » Unix » help ! why can't i use @ to run a script file in HP-UX 11i (b23)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help ! why can't i use @ to run a script file in HP-UX 11i (b23) [message #126433]

Mon, 04 July 2005 08:20

pengje
Messages: 2
Registered: July 2005
Location: china

Junior Member

Good evening ,everybody.
i am a beginner of unix,i met a strange problem .
when i use @xx.sql to run a script in sqlplus at hp-ux11i ,i get
a error message:
SQL> @ test.sql
SP2-0042: unknown command "test.sql" - rest of line ignored.
SQL>
SQL> start test.sql

SYSDATE
---------
04-JUL-05

my oracle is oracle9.2
SQL> select * from v$version
2 /

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
PL/SQL Release 9.2.0.2.0 - Production
CORE 9.2.0.2.0 Production
TNS for HPUX: Version 9.2.0.2.0 - Production
NLSRTL Version 9.2.0.2.0 - Production

who can tell me why i can not use @ at hp-ux 11i
thanks
and regards

Report message to a moderator

Re: help ! why can't i use @ to run a script file in HP-UX 11i (b23) [message #126591 is a reply to message #126433]

Tue, 05 July 2005 15:55

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Works fine in my environment using KSH. Maybe it's something in your profile.
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production

SQL> @t.sql

SYSDATE
------------------
05-JUL-05

SQL> @ t.sql

SYSDATE
------------------
05-JUL-05

SQL> ! uname -r
B.11.11

Report message to a moderator

Re: help ! why can't i use @ to run a script file in HP-UX 11i (b23) [message #126741 is a reply to message #126591]

Wed, 06 July 2005 07:50

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

Do a "stty -a" to see if the "@" character is used as a terminal control character.

Best regards.

Frank

Report message to a moderator

Re: help ! why can't i use @ to run a script file in HP-UX 11i (b23) [message #126767 is a reply to message #126741]

Wed, 06 July 2005 09:34

pengje
Messages: 2
Registered: July 2005
Location: china

Junior Member

Frank and Andrew ,thank you very much
in my environment ,when i user 'stty -a ', i found 'kill=@'
when i set other charactor for kill,i solved the problem .
best regards to you all

Report message to a moderator

Previous Topic:	Oracle 817, Solaris 8, Out of memory, ORA-27102
Next Topic:	How to get a var from SQL in a unix shell

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:43:14 CDT 2024