HTTP

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...