Re: Re: SQL plus howto start a script

[Quoted] 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 - 08:40:39 CEST