Oracle procedure to generate HTML contain two select queries - repost 2

Hi guys, I HAVE REPOSTED THIS PROJECT BECAUSE I AM NOW AWARE OF METHOD I'D LIKE TO FOLLOW THANK YOU FOR READING 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 TWO select queries I have written , one of them outputs about 8 columns of 300 rows.. the other outputs 2 columns of 4 or 5 rows.. THE PROBLEM: I basically want to get this information from my friend's server to my computer by generating HTML on the server, that my computer can then scrape off the webpage. I think it is too dangerous to use port 1521 and open up Oracle over the internet.. THE SOLUTION: Write an Oracle procedure. This procedure calls my two SELECT queries The Oracle procedure writes to an HTML file eg [login to view URL] That is a blank page, but data is contained inside comments, (or a tag) e.g. generated code: [login to view URL] is stored in the relevant Apache folder eg httpdoc etc [body] [!-- [Q1]'34','2/1','Leeds','OnlyGotThreeLegsHorsey','2:40','4/1','6/1','5/4'[/newline] '34','2/1','Leeds','LuckyFucker','2:40','2/1','3/2','2/1'[/newline] '34','2/1','Leeds','UnLuckyFucker','2:40','100/1','100/1','90/1'[/newline] ... '34','2/1','London','AverageMrHorse','4:00','8/1','7/2','8/1' [Q2]'Leeds','2:40','3:10','3:40','4:10','4:45'[/newline] 'London','2:50','3:20','3:50','4:20','5:00'[/Q2] ->] [/body] NOTE: I have to use [ instead of < because freelancer page messes up otherwise.. i would also like to add some basic security. QUESTIONS: 1) The data is public information and not particularly sensitive, however if possible it would be nice to make private as possible. I could name the html file something like '[login to view URL]' Would this file be publically searchable? 2) Is there a simple way to encrypt this data? Either using Oracle or Apache 3) Or is it easy enough to generate a password for the webpage? In which case my Python code on client side would need to be able to enter password/decrypt. MORE DETAILS; The procedure is to be called from another procedure that is run by the Oracle job scheduler. I will write the code to scrape the HTML on my computer I could code the Oracle procedure myself, just I haven't used Oracle for 10 years, so quicker if I can get someone else to write. 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. Are you able to provide me with the procedure and I will install myself on the system? I may need to ask some beginner questions if I get stuck doing this! If you needed to work on the system, possibly you could remote log onto my machine, and my machine is remote logged on to his server. I would have to get permission first. Feel free to ask any questions! Thank-you for reading!