How i can, execute a .sql file by ftp.

I tried, sqlplus USER/PASS@SID
@ftp://xx.xxx.xx.xxx/mydir/mydir/myfile.sql

But, don't work.


Thank's ¡¡

what version of sqlplus?

I know that http is supported as of 9.2, but haven't kicked the tires
on ftp.

Here is a link to the 10.1 docs on this subject:
http://download-west.oracle.com/docs...3.htm#i2696724

-bdbafh

daniellopez21 wrote:
> How i can, execute a .sql file by ftp.
>
> I tried, sqlplus USER/PASS@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

fitzjarrell@cox.net wrote:
> daniellopez21 wrote:
>
>>How i can, execute a .sql file by ftp.
>>
>>I tried, sqlplus USER/PASS@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...

Frank van Bortel wrote:
> fitzjarrell@cox.net wrote:
> > daniellopez21 wrote:
> >
> >>How i can, execute a .sql file by ftp.
> >>
> >>I tried, sqlplus USER/PASS@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...3.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.


David Fitzjarrell

<fitzjarrell@cox.net> wrote in message
news:1126817414.130355.120220@g47g2000cwa.googlegr oups.com...

Frank van Bortel wrote:
> fitzjarrell@cox.net wrote:
> > daniellopez21 wrote:
> >
> >>How i can, execute a .sql file by ftp.
> >>
> >>I tried, sqlplus USER/PASS@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...3.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://usernameassword@xx.xxx.xx.xxx/mydir/mydir/myfile.sql

Matthias

Tnahk you

With @ftp://usernameassw...@xx.xxx.xx.xxx/mydir/mydir/myfile.sql ,
yes work.

Agggssss. i have a problem?¿? :S

This statment work in sqlplus 9.2.0.6.0 in Solaris, but i don't work in
9.2.0.1.0 in Windows 2000.

daniellopez21 wrote:
> Agggssss. i have a problem?¿? :S
>
> This statment work in sqlplus 9.2.0.6.0 in Solaris, but i don't work in
> 9.2.0.1.0 in Windows 2000.


This is one reason why you patched the server to 9.2.0.6. You should
also patch the client software.


David Fitzjarrell