5 Replies Latest reply on Jan 15, 2010 9:15 AM by 746707

    SP2-0556: Invalid file name while connecting to sqlpls Oracle 10g

    555778
      I created a shell with this command :

      sqlplus -s apps/$pwd@$dbname @$XO2C_TOP/bin/XO2C_CUST_SNP_TBLGEN.sql

      It gives me an error

      SP2-0556: Invalid file name

      The same command rusn fine when i execute at the shell prompt.

      I tried many options, removed the -s , expanded the $XO2C_TOP but no use, i get the same error.
      The file is definitely there, it executes when i just copy the line from the shell script and paste in at the unix prompt.

      Please help, I can't figure out what the issue here is.

      thanks
      satya