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

From: <cbbakshi_at_aol.com>
Date: Wed, 9 Feb 2011 01:25:42 -0500 (EST)
Message-Id: <8CD96394E051C6B-1798-54BBD_at_webmail-d137.sysops.aol.com>

set termout on and execute abc.sql (SQL>_at_abc.sql) it gives output. Thanks all.

-----Original Message-----

From: cbbakshi <cbbakshi_at_aol.com>
To: email2sood <email2sood_at_gmail.com>; oracle-l <oracle-l_at_freelists.org> Sent: Wed, Feb 9, 2011 5:38 am
Subject: Re: _at_ command does not work in SQL PLUS (OS HP-unix)

I dont see _at_ 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_at_gmail.com> To: cbbakshi <cbbakshi_at_aol.com>
Cc: oracle-l <oracle-l_at_freelists.org> Sent: Wed, Feb 9, 2011 2:47 pm
Subject: Re: _at_ command does not work in SQL PLUS (OS HP-unix)

Hi,

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

With Regards,
Saurabh Sood
www.askdba.org/weblog

On Tue, Feb 8, 2011 at 7:15 PM, <cbbakshi_at_aol.com> wrote:

Hi,

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

         1

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

SQL>  _at_abc.sql
SQL>
SQL>

Could you please help me in resolving this issue?

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

select 1 from dual
/

Thanks and Regards,
Chandra  

--

SAURABH SOOD
ORA-DBA    
--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 09 2011 - 00:25:42 CST