Re: DSN in SQL Plus line? - Correction

OK, so I had a senior moment:

The script idea works well IF you are logged into SqlPlus not the way I described it before...

You would need to call PLUS80 and pipe the script to it as input, then it might work OK...
IN any event, the method I posted will NOT do the job...Sorry....

johng_at_mm.com (TurkBear) wrote:

>
>
>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! =-----

-----= 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