Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: DSN in SQL Plus line?
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
Received on Mon Jun 12 2000 - 00:00:00 CDT
![]() |
![]() |