OraFAQ Forum: SQL & PL/SQL » Running script present on webserver

Home » SQL & PL/SQL » SQL & PL/SQL » Running script present on webserver (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running script present on webserver [message #681326]

Wed, 08 July 2020 08:35

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Hi

I want to run a PL SQL sript present on a webserver.

Need guidance.

the script a.sql is present here.

https://naveed110.000webhostapp.com/a.sql

After Connecting user scott, i can not run the script with following command

@https://naveed110.000webhostapp.com/a.sql

Guide me what i am missing.

Report message to a moderator

Re: Running script present on webserver [message #681327 is a reply to message #681326]

Wed, 08 July 2020 09:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

on which system does the Oracle database reside?

Report message to a moderator

Re: Running script present on webserver [message #681328 is a reply to message #681327]

Wed, 08 July 2020 09:36

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

it is residing in windows environment.

tried to call from host as well with different combination but failed.


host cmd /k sqlplus scott/s@hp "@naveed110.000webhostapp.com/a.sql"


host cmd /k sqlplus  scott/s@hp "@naveed110.000webhostapp.com//a.sql"


host cmd /k sqlplus  scott/s@hp "@naveed110.000webhostapp.com\a.sql"


host cmd /k sqlplus scott/s@hp "@naveed110.000webhostapp.com\\a.sql"




 



host cmd /k sqlplus scott/s@hp @naveed110.000webhostapp.com/a.sql


host cmd /k sqlplus  scott/s@hp @naveed110.000webhostapp.com//a.sql


host cmd /k sqlplus  scott/s@hp @naveed110.000webhostapp.com\a.sql


host cmd /k sqlplus scott/s@hp @naveed110.000webhostapp.com\\a.sql

Report message to a moderator

Re: Running script present on webserver [message #681329 is a reply to message #681328]

Wed, 08 July 2020 10:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I wanted to know if the Oracle database is installed & running on the same system that is webserver.
REALIZE that Windows OS knows NOTHING about SQL or what to do with any SQL statement.
REMEMBER that the web interface is STATELESS. This means that as far as the webserver is concerned, it knows nothing about any previous command.
I have no idea how or why you believe that you logged into the DB as USER SCOTT, the next HTTP command has no history or relationship to previous activity.
I suggest you go find a working example of how to interface webserver to Oracle database, because your current approach won't work.

Report message to a moderator

Re: Running script present on webserver [message #681330 is a reply to message #681329]

Wed, 08 July 2020 10:49

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Oracle database is installed locally on office computer while webserver is at some remote location.

Basically my objective is to run a script file present on remote webserver.

as per SQL*Plus user guide
Quote:

<start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]

Runs the specified SQL*Plus script from a web server (URL) or the
local file system (filename.ext) with specified parameters that
will be assigned to substitution variables in the script.

Stil need guidance

Report message to a moderator

Re: Running script present on webserver [message #681331 is a reply to message #681330]

Wed, 08 July 2020 11:54

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

First, can you ftp the remote file from the office computer?
Note that "failed" (as well as "i can not run the script") is not an Oracle error and help us in no way to understand where the "error" (is there an error? "failed" does not even give clue about that) come from.

Report message to a moderator

Re: Running script present on webserver [message #681332 is a reply to message #681326]

Wed, 08 July 2020 14:27

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

From the 19c docs,Quote:

Specifies the Uniform Resource Locator of a script to run on the specified web server. SQL*Plus supports HTTP and FTP protocols, but not HTTPS. HTTP authentication in the form http://username:password@machine_name.domain... is not supported in this release.

so you can't use https.

Report message to a moderator

Re: Running script present on webserver [message #681335 is a reply to message #681332]

Wed, 08 July 2020 16:23

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Thank you for your advice.

I did it with following command

host cmd /k sqlplus  scott/s@hp @http://naveed110.000webhostapp.com//a.sql

Thank you for giving your precious time !

Report message to a moderator

Previous Topic:	Identify the format and display the data type of a string
Next Topic:	Run Time Errors 933 and 512 executing Proc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 27 23:35:03 CDT 2023