Re: @ command does not work in SQL PLUS (OS HP-unix)

  • From: cbbakshi@xxxxxxx
  • To: email2sood@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 9 Feb 2011 00:16:51 -0500 (EST)

I dont see @ here

$ stty -a
#2 disc;speed 38400 baud; 42 rows; 125 columns
erase = ^H; werase = ^W; kill = ^U; intr = ^C; quit = ^\; susp = ^Z
dsusp = ^Y; eof = ^D; eol = <undef>; eol2 = <undef>; stop = ^S
start = ^Q; lnext = ^V; discard = ^O; reprint = ^R; status = <undef>
time = 0; min = 1
-parenb -parodd cs8 -cstopb hupcl cread -clocal -crtscts
-ignbrk brkint -ignpar -parmrk -inpck -istrip -inlcr -igncr icrnl -iuclc
ixon -ixany ixoff imaxbel
isig icanon -xcase echo echoe echok -echonl -noflsh -mdmbuf -nohang
-tostop echoctl -echoprt echoke -altwerase iexten -nokerninfo
opost -olcuc onlcr -ocrnl -onocr -onlret -ofill -ofdel tabs -onoeot

-----Original Message-----
From: Saurabh Sood <email2sood@xxxxxxxxx>
To: cbbakshi <cbbakshi@xxxxxxx>
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wed, Feb 9, 2011 2:47 pm
Subject: Re: @ command does not work in SQL PLUS (OS HP-unix)


You can check the terminal settings of HP-UX  for @
I think stty -a  will show that. If @ is mentioned there then change it with 
some other character.

With Regards,
Saurabh Sood

On Tue, Feb 8, 2011 at 7:15 PM,  <cbbakshi@xxxxxxx> wrote:


I have a sql file (abc.sql) which contains some code. I am able to run this 
using "run" command as 
SQL> run abc.sql
  1* select 1 from dual



But not able to execute using "@" command. If i execute using @ it just return 
to the SQL prompt without executing this file.
SQL>  @abc.sql

Could you please help me in resolving this issue?

FYI, I m using Oracle on HP-unix (Tru64 UNIX V5.1B (Rev. 2650)
Content of abc.sql is 

select 1 from dual

Thanks and Regards,




Other related posts: