Re: DSN in SQL Plus line?

The Sql Script can prompt for the values , see the Accept and Prompt commands in the SqlPlus docs...

the script would look like this ( not to be used as is, written from memory)

Accept Uname Prompt Enter your Oracle User Name Accept Pass prompt Enter password HIDE
plus80 &Uname/&pass_at_ROBERT.WORLD @myfile.sql

hth,

"Robert Wagner" <RobertWagner_at_alum.mit.edu> wrote:

>OK, here's one more question:
>
>How do I handle it when I know the DSN but _don't know_ the username. For
>example, I ship the batch and script files to my customer, but I don't know
>who's actually going to be using them.
>
>Thanks again >>>> Robert
>
>"David Van Zandt" <dvanzandt_at_iquest.net> wrote in message
>news:39423B17.97C1BE13_at_iquest.net...
>> Unless I'm missing something obvious, you're omitting the
>> username/password (prior to the @ROBERT).
>>
>> To quit in batch, as in command line: EXIT
>>
>> HTH,
>> dvz
>>
>> Robert Wagner wrote:
>> >
>> > I'm using SQL Plus in "batch mode" to do updates, etc. Right now, I'm
>> > working off a local database in Oracle8 personal, but eventually it'll
 be on
>> > a server. So a need to provide the DSN in the command line as suggested
>> > inOracle Desk Reference, by Guy Harrison. But it doesn't work. Here's
 the
>> > batch file:
>> >
>> > PLUS80 @ROBERT.WORLD @Myfile.sql
>> >
>> > "@ROBERT.WORLD " is supposed to connect me through the DSN, but it
 doesn't
>> > work.
>> >
>> > What am I doing wrong?
>> >
>> > Also, how do I quit PLUS80 at the end?
>> >
>> > TIA Robert
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Jun 12 2000 - 00:00:00 CDT