Re: sqlplus doing ftp :)

Thanks, Brian :)

Niall, good idea, I'll edit it a bit & post it to Jonathan during weekend.

Tanel.

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F3CD859.80596836_at_remove_spam.peasland.com...
> I like your solution!
>
> Cheers,
> Brian
>
> Tanel Poder wrote:
> >
> > Hi!
> >
> > > I saw this functionality quite some time ago. But I didn't do anything
> > > about it because it was easier for me to set SQLPATH and store the
> > > scripts locally. It's just too longwinded to prepend the script with a
> > > URL. But the feature is nice! Maybe in Oracle 10.0.2 they will let you
> > > use some sort of environment variable here. And it should have the
> > > ability to search multiple web servers, in order.
> >
> > I was thinking about long url problem solutions here... one would be to
map
> > your web location to a local directory using webdav (where possible).
> > But this is even better:
> >
> > SQL> @http://localhost:7778/rinit.sql
> > @http://localhost:7778/&1
> >
> > SQL> @r instance.sql
> >
> > TIME USER INSTANCE_NAME HOST_NAME
> > ----------------- ---------- ---------------- ----------
> > 20030815 03:04:14 ADMIN orcl PORGAND
> >
> > SQL>
> >
> > I have a script named instance.sql in my web location and rinit.sql
contents
> > are very simple:
> >
> > set define \
> > spool r.sql
> > prompt @http://localhost:7778/&1
> > spool off
> > set define &
> >
> > The only problem is that you have to type .sql in the end of script
name,
> > but I do mostly anyway. Also, if you want to give parameters to your sql
> > script from command line, you might have to modify rinit script...
> >
> > Tanel.
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Fri Aug 15 2003 - 12:02:51 CDT