Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlplus variable

RE: sqlplus variable

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Mon, 23 Oct 2006 15:10:38 -0500
Message-ID: <B39B7B7D8C8CEA419D0ED45FD7FA4C5301B36373@CWYMSX06.Corp.Acxiom.net>


Not a "bash" guy but maybe you just need to put this on separate lines or use a ";" (semicolon) in between
or like ksh
say
export SQL_UTILITY='sqlplus /nolog'


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Monday, October 23, 2006 3:01 PM
To: oracle-l
Subject: sqlplus variable

Hello all,  

I've been trying to script a backup that uses sqlplus /nolog as a variable. I create the variable as:
SQL_UTILITY='sqlplus /nolog' export SQL_UTILITY  

in my bash script but when I execute it I get:  

': not a valid identifier

I've tried a bunch of different combos but still get the same error. Which part is wrong?

If I just type this at the command line and then echo back $SQL_UTILITY, it works. What could be wrong script-wise?

ciao,
Brian  

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.



The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 23 2006 - 15:10:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US