Re: window solution :-)

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:C8ednTXjjc7qoYbfRVn-qw_at_comcast.com...
>
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
> news:1109080132.816614.276640_at_c13g2000cwb.googlegroups.com...
>> Good try. See comments embedded.
>>
>> jazzz_ wrote:
>>> OK, thanks for your help
>>> I found solution.
>>>
>>> here is Windows version:
>>>
>>> 1. Make batch file 1.sql which include:
>>>
>>> sqlplus @c:\username.sql
>>>
>>> 2. Make file username.sql and inside put:
>>>
>>> us/pass_at_db
>>
>> Put connect keyword in the beginning i.e. connect us/pass_at_db
>>
>
> good catch... but then the batch file must include the /NOLOG command
> line option
>
> the OP might want to consider just using CONNECT without hard-coding the
> db credentials, letting SQL*Plus prompt for the credentials
>
> or, pass the credentials via the command line (just deferring the issue,
> but perhaps deferring it to a more centralized and controllable location):
>
> sqlplus -s /nolog @usernames.sql scott/tiger_at_orcl
>
>

umm.... excuse me, that last suggstion of mine was dumb.

if the credentials are passed via the command line, then the /nolog and CONNECT are not necessary

and, if the OP wants sqlplus to prompt, then just don't supply any credentials anywhere

so, the point should have been -- if CONNECT is used, the /NOLOG option is required.

++ mcs Received on Tue Feb 22 2005 - 08:25:55 CST