3 Replies Latest reply: Sep 16, 2011 8:28 AM by 839293 RSS

    Special Character in Filename script - how do I escape it.

    Kennedy
      Hello All. I'm attempting to call a file in sqlplus on a linux box. The file name has a special character.

      ex: i$_my_script.sql

      I've attempted to use

      @i$_my_script.sql

      @i\$_my_script.sql

      @i\\$_my_script.sql

      @"i$_my_script.sql"

      @'i$_my_script.sql'

      @'i\$_my_script.sql'

      All to no avail. I could have sworn I'd called a similar file with $ in the filename before but now I can't get it to work. Preference would be to no have a special character in the filename ... but the file is coming in from a source I don't have control over. I could rename the file but the file resides in a source control system and I'd prefer not to have to rename it every time I want to compile it.

      Thanks in advance.
      edit<<
      Also as a note I can see the file in sqlplus by sending ls to the command line as follows:

      SQL> ! ls i\$_my_script.sql

      which returns

      i$_my_script.sql

      Edited by: Kennedy on Sep 6, 2011 1:25 PM