Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Double Quotes preservation while passing parameters.

Double Quotes preservation while passing parameters.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 6 Jul 2004 14:29:07 -0500
Message-ID: <uvfh10wh5.fsf@standardandpoors.com>


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 Boyer
Received on Tue Jul 06 2004 - 14:29:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US