By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,407 Members | 1,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,407 IT Pros & Developers. It's quick & easy.

Passing a space as an argument to SQL*Plus

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.