Is it possibel to read an HTTP file and pu the contencts into a datbase using plsql?
Its justa query..and believe me ...i stopped watching STAR TRECK!!!!
Printable View
Is it possibel to read an HTTP file and pu the contencts into a datbase using plsql?
Its justa query..and believe me ...i stopped watching STAR TRECK!!!!
HTTP is a transfert protocol, I guess you mean HTML ... well as long as you have an access to a file (means you can download it), you can do whatever you want using UTL_FILE !
I it possibel for me to read the file from the web server itself?
like...fopen("http://ghffddf","a1.html","r")
no, but you can use UTL_HTTP to get the page
Can u tell me the usage of this and what all packages to be xecuted for this?
just look at Oracle documentation, section : Supplied Packages Reference, and you'll get all the syntax and exemples you need to use supplied packages, like UTL_FILE, UTL_HTTP or UTL_SMTP ...
Here is the doc that might help you to undestand what pipo says.
http://www.oradoc.com/ora816/server.816/a76936/toc.htm
Sam
thank you...