Re: Q: Command line paramaters and SQL*Plus
Date: 1996/08/09
Message-ID: <4ugk23$ppg_at_zimmer.CSUFresno.EDU>#1/1
In article <4ug4cn$dd9_at_linet01.li.net>, Gary Assa <gsa_at_li.net> wrote:
>I am passing SQL*Plus a bunch of paramaters, with some of them having
>spaces within the paramater. This causes SQL*Plus to see them as
>seperate paramaters. I have tried enclosing them in all kinds of
>quotes but to no avail. Here is my example.
>
>sqlplus _at_{sql_script} "{printer_name}" "08/08/96 11:45 am" "08/08/96 16:45 pm"
>
>This report prints to a printer all records falling between those date/time's.
>
>Problem is, the script uses 08/08/96 as paramater 2 and 11:45 and paramater 3.
Send your parameter with some unused character (maybe an underscore: _ ) where the spaces are. In Sql Plus, take the special characters out with the translate function:
New_string := translate(old_string,'_',' ');
HTH
Steve Cosner
Received on Fri Aug 09 1996 - 00:00:00 CEST