Running sql file stored in internet directory

[joness59]

I have a directory on the Internet where I store many of my scripts so I have access to them from basically anywhere. Is there a way to run these scripts in a way similar to SQL*Plus? Example:

@http://www.site.com/oracle/script.sql

TIA

S Jones

 

[CTzen]

wow, another cool feature

didn't know about it, now I need to find how I can use it

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[CTzen]

Marco, that would be a nice feature for sure. By the way documentation mentioning that @ftp://... should work as well (I have not tried it though)

S Jones, I have a question for you as well

I tried to add 'http://server/scriptdir' to SQLPATH variable in a hope SQL*Plus would recognize it, but it didn't work for me neither on Unix nor on Windows. On Unix SQL*Plus treats ':' as directory separator, so it adds script name to http/ and then to //server/scriptdir/ and it doesn't work of cause.

Replacing ':' with %3A didn't help either.

So I'm wondering if there is any way to make SQL*Plus to look for the scripts on the web server?

 

[joness59]

I've tried setting a variable to the URL where my scripts are stored, but it doesn't work and I'm not sure why. The only way I've gotten it to work is to type the URL in SQL*Plus directly.

S Jones

 

[CTzen]

It's a pity, I hope Oracle will let us do it in the future.