Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: DSN in SQL Plus line?

Re: DSN in SQL Plus line?

From: Robert Wagner <RobertWagner_at_alum.mit.edu>
Date: 2000/06/12
Message-ID: <yca15.3303$9E6.29718@newsr1.maine.rr.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US