It is currently Thu, 20 Jan 2022 11:16:41 GMT



 
Author Message
 Bad Substitutions
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



 Fri, 08 Sep 2006 13:48:27 GMT   
 Bad Substitutions

    I assume you mean:

RunOracleSQL $OMS_SQLBAT/IPR_DC_MANU_ITEMData.sql OMS_IPRLOGON \
  "${SpoolFileDir}/${SpoolFileName} ${ErrorFileDir}/${ErrorFileName}"

    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



 Fri, 08 Sep 2006 14:27:53 GMT   
 
   [ 2 post ] 

Similar Threads

1. Bad substitution

2. bad Substitution in bash

3. bad substitution

4. bash bad substitution

5. Command Substitution within Parameter Substitution?

6. Substitution within substitution- Is it possible?

7. SoftwarBuyLine.com is bad, bad, bad...

8. Bad, bad, bad error...

9. Bad, bad, bad VM behaviour in 2.4.10

10. Bad driver...Bad bad driver


 
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software