Re: SqlPlus by ftp

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 16 Sep 2005 01:22:34 +0200
Message-ID: <432a023b$0$23199$ba620e4c@news.skynet.be>

<fitzjarrell_at_cox.net> wrote in message
news:1126817414.130355.120220_at_g47g2000cwa.googlegroups.com...

Frank van Bortel wrote:
> fitzjarrell_at_cox.net wrote:
> > daniellopez21 wrote:
> >
> >>How i can, execute a .sql file by ftp.
> >>
> >>I tried, sqlplus USER/PASS_at_SID
> >>@ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql
> >>
> >>But, don't work.
> >>
> >>
> >>Thank's กก
> >
> >
> >
> > Does this work without a login and password:
> >
> > ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql
> >
> > This may be the source of your problems as anonymous ftp must be
> > configured for such calls to work.
> >
> >
> > David Fitzjarrell
> >
> Apart from that - should it not be:
> host ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql,
> instead of:
> @ftp...
> ?

>

> --
> Regards,
> Frank van Bortel

>
> Top-posting is one way to shut me up...

According to the documentation
(http://download-west.oracle.com/docs/cd/B14117_01/server.101/b12170/ch13.htm#i2696724) his syntax is correct. Note the link shows both http and ftp using the @ shortcut to execute a script. My guess is anonymous ftp is not enabled, a username and password are not supplied, and the connection fails and thus the script is never loaded into the buffer.

Maybe this works :
@ftp://username:password@xx.xxx.xx.xxx/mydir/mydir/myfile.sql

Matthias Received on Thu Sep 15 2005 - 18:22:34 CDT