Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Double Quotes preservation while passing parameters.
I have the following sqlfile between the line of ###
##################################################
prompt &1
prompt &2
exit
##################################################
I called this file tmp.sql
So, if I pass this file double quoted parameters, the output doesn't preserve the double quotes. I need it to.
FOR EXAMPLE
SHELL> sqlplus -S galen/galen @tmp xxx "'hello goodbye'"
xxx
hello goodbye
I need the output to show
SHELL> sqlplus -S galen/galen @tmp xxx "'hello goodbye'"
xxx
"hello goodbye"
Is there a sqlplus option for this, or another way that anybody knows of?
-- Galen BoyerReceived on Tue Jul 06 2004 - 14:29:07 CDT
![]() |
![]() |