Re: Passing String Arguments to SQL*Plus from a Unix Shell

<quote who="Nigel Thomas">

> $ sqlplus -s nthomas/nthomas <<END
>
>> define 1="'1','2'" define 2="'3','4'" @show_inputs
>> exit END
>>
>
> P1='1','2'
> p2='3','4'

Good idea! I must confess that I used this method in other cases but I was so stuck in my approach that I didn't think of that. Thanks for showing me the light. ;-)

Regards,
Uwe

--
http://www.freelists.org/webpage/oracle-l