469,898 Members | 2,360 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Passing a space as an argument to SQL*Plus

GP
Consider the following: (extracted from a .bat)

sqlplus toto/titi ^
@%pdl%\islqz033 ^
'1 ' ^
'aaa' ^
' ' ^
'zzz' ^
....
At execution, SQL*Plus stops and ask for the parameter corresponding
to the blank spaces(' ') parameter.

In 8.0 it was working fine, but in 9.2 SQL*Plus does not like it.

I have multiple .bat that use that approach, so a solution with
minimal impact would be appreciated.

Thanks !

NOTE: I've tried both 'set COMPATIBILITY V8' and 'SET
SQLPLUSCOMPATIBILITY 8.0.0' with no luck...
Jul 19 '05 #1
0 1811

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ruben Schoenefeld | last post: by
3 posts views Thread by khangu | last post: by
3 posts views Thread by Peter | last post: by
2 posts views Thread by Ant | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.