|
Home > Archive > Unix Shell > March 2004 > Bad Substitutions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Sujay Ghosh 2004-03-22, 1:34 am |
| Hello ,
In my UNIX shell script I have assigned variables with the
corresponding values as below :-
SpoolFileDir=${OMS_IMP_DIR}
SpoolFileName=IPR_ITEM_Import.dat
ErrorFileDir=${OMS_IMP_DIR}
ErrorFileName=IPR_ITEM_Error.dat
After setting up of these variables , I am calling Oraccle to
execute a SQL file , with the above vars as the parametes
RunOracleSQL $OMS_SQLBAT/IPR_DC_MANU_ITEMData.sql OMS_IPRLOGON
"${SpoolFileDir}/${Spo
FileName} ${ErrorFileDir}/${ErrorFileName}"
On execution of the shell scipts, I get an error, "RunOracleSQL <
absolute spool file name absolute error file name> bad substitution"
Any pointers to this would be very helpful .
Thanks in advance ,
Sujay
| |
| Chris F.A. Johnson 2004-03-22, 1:34 am |
| On Mon, 22 Mar 2004 at 05:48 GMT, Sujay Ghosh wrote:
> Hello ,
>
> In my UNIX shell script I have assigned variables with the
> corresponding values as below :-
>
> SpoolFileDir=${OMS_IMP_DIR}
> SpoolFileName=IPR_ITEM_Import.dat
>
> ErrorFileDir=${OMS_IMP_DIR}
> ErrorFileName=IPR_ITEM_Error.dat
>
>
> After setting up of these variables , I am calling Oraccle to
> execute a SQL file , with the above vars as the parametes
>
> RunOracleSQL $OMS_SQLBAT/IPR_DC_MANU_ITEMData.sql OMS_IPRLOGON
> "${SpoolFileDir}/${Spo
> FileName} ${ErrorFileDir}/${ErrorFileName}"
I assume you mean:
RunOracleSQL $OMS_SQLBAT/IPR_DC_MANU_ITEMData.sql OMS_IPRLOGON \
"${SpoolFileDir}/${SpoolFileName} ${ErrorFileDir}/${ErrorFileName}"
> On execution of the shell scipts, I get an error, "RunOracleSQL <
> absolute spool file name absolute error file name> bad substitution"
The error appears to be generated by Oracle; there's nothing wrong
with the script once the above correction is made. Make sure that
your variables are correctly defined.
--
Chris F.A. Johnson http://cfaj.freeshell.org/shell
========================================
===========================
My code (if any) in this post is copyright 2004, Chris F.A. Johnson
and may be copied under the terms of the GNU General Public License
|
|
|
|
|