Re: SQL plus howto start a script

Can't do that bec
it has to run on the server
I'm connected by the internet

Reinier wrote:

> So you mean that e: drive is not locally mapped...? no wonder you cannot
> find it by typing 'e:\...blabla'.
>
> Try mapping this server to a local drive-letter.
>
> Greg <actiris_at_loxinfo.co.th> wrote in message
> news:39D184C6.CD3DC21C_at_loxinfo.co.th...
> >
> >
> > "Matt B." wrote:
> >
> > > "Greg" <actiris_at_loxinfo.co.th> wrote in message
> > > news:39D0213C.C088D2CE_at_loxinfo.co.th...
> > > > I like to start that script from a client.
> > > > the script is located on the server in
 e:\server\localdir\my_script.sql
> > > >
> > > > so I try
> > > >
> > > > _at_my_script
> > > > sure he can't find it bec its on the server not on my local machine
> > >
> > > Right.
> > >
> > > > _at_e:\server\localdir\my_script
> > > > dosent work too, same reason.
> > > >
> > > > how to give the start command the information that the
> > > > given path is on the server not locally.
> > >
> > > I'm pretty sure the latter should work. Is your default file extension
 set to
> > > "sql" in your settings? Do a SHOW ALL and see if the default file
 extension
> > > for scripts is set to "sql" (usually is). If your server is UNIX, bear
 in mind
> > > that the file name might be case-sensitive too.
> > >
> > > -Matt
> >
> > Thanks BUT
> >
> > Working on NT Server, Workstation
> >
> > SQL Parameter ist set to
> >
> > sqlprompt "base1_LOGAP> "
> > sqlterminator ";" (hex 3b)
> > suffix "sql"
> >
> > think about it
> > the SQL plus on my Worbox looks in to the
> > local drives. Exept I set up a Network drive link in the
> > settings of the start link from SQLplus
> > So there must be an additional keyword to
> > point to the Server and look into e:\server\localdir\my_script
> >
> > Greg
> >
Received on Wed Sep 27 2000 - 10:07:48 CEST