On a webserver, output rows of an Oracle query onto a seperate webpage..
$30-250 USD
Cancelado
Publicado há mais de 10 anos
$30-250 USD
Pago na entrega
Hi guys,
A friend of mine has a small website online. It has about 25 users that subscribe to it and it is live, (so I have to take precautions not to crash it).
The server is Windows Server 2003
It runs Oracle 10g XE, Apache http server
It also uses PL/SQL to write http
I have a select query I can run that outputs about 8 columns of 300 rows..
THE PROBLEM:
I basically want to get this information from my friend's server to my computer every day.
Can you offer an elegant solution?
We could create a job to send an email everyday, or ftp it..
But I figured the best way is to create a private webpage, and everytime the webpage is called, it outputs the 300 rows to the webpage..
Then just scrape this webpage..
When I look at [login to view URL]
I see this:
document.location.href="pls/gn/[login to view URL]"
I'm looking for a solution to this problem.
Can you offer one and give a quote? Can you write some code that will create a webpage and then some code in Python I can run on my machine to scrape this data and put into a Python dictionary?
AN ISSUE:
My friend has given me access to the server also the Oracle passwords. However I am not 'allowed' to let anyone else have this.
However. If you needed to work on the system, you could remote log onto my machine, and my machine is remote logged on to his server.
OR perhaps there are other ways.. I could create an Oracle view, create a user and give access to the user read access to this view etc..
Feel free to ask any questions!
Thank-you for reading!
I have worked with Oracle technology, I can build a e-mail for you with critical information about you Windows, Oracle database and Apache http Server.