Whoops, incomplete copy and paste! I'm AFK now, but when I tried to run the script from within SQL*Plus, I got the same "unable to open file" message.
Regards, John P. (Strange spelling? iPhone's fault. Strange content? Alas, that's all me)On May 6, 2010, at 4:18 PM, "S. Anthony Sequeira" <tony@xxxxxxxxxxxxxxx> wrote:
On 06/05/10 21:06, John Piwowar wrote:Hi Tony,In the bash shell, at least, it looks like the $ is interpolated if not escaped, and confusing to SQL*Plus even if it is escaped. Granted, this might be a peculiarity of the OS X SQL*Plus client.zathras:SQL jpiwowar$ sqlplus jpiwowar@MACTEST @te$t.sql SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 6 16:00:36 2010 <header trimmed> SP2-0310: unable to open file "te.sql" zathras:SQL jpiwowar$ sqlplus jpiwowar@MACTEST @te\$t.sql SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 6 16:00:48 2010 <snip-snip> SP2-0310: unable to open file "te$t.sql" Regards, John P.Hi John, Thanks for the reply.Yes, if it's run on the command line, I can quite understand it. It will happen with any Unix OS AFAIK.But if it's run from within SQL*Plus? Regards -- Tony
-- //www.freelists.org/webpage/oracle-l