Re: window solution :-)

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 22 Feb 2005 09:06:40 -0500
Message-ID: <C8ednTXjjc7qoYbfRVn-qw@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 Received on Tue Feb 22 2005 - 08:06:40 CST