Yes, this is possible. I have experimented on Oracle 11g the UTL_HTTP package and it works! The standard calls are documented with this package and it works with http (non SSL encrypted) sites. If you need to access an SSL encrypted page, you need to do additional work setting up an "Oracle Wallet" on your server to handle the SSL encryption certificate. If you are on a later (newer) version of Oracle (10g, 11g) you will also need to define an ACL (Access Control List) which defines permissions for the user account/schema attempting the http request, the target urls/domains and ports also have to be defined in the ACL.
I was able to piece together the know how thorugh a few searches, and while the collective knowledge on the net is sparse, there are a few resources out there with examples. Let us know if you have any questions on specifics. Good luck Martin! Rich Pascual On Thu, Jul 8, 2010 at 1:01 PM, Martin Fischer < martin.fischer.1...@gmail.com> wrote: > Hi there, > > i need a hint > > I need to acces an external server on the internet. > > This one answers on a special url including access-codes with a > "website"-string that i need to analyse. > > Is it possible to write a PL-SQL-Function which is using this internet- > server and how have i to do this ? > > best regards > > Martin > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
