Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Oracle AS/Integration
icon4.gif  Oracle AS/Integration [message #146278] Wed, 09 November 2005 12:35 Go to next message
Messages: 1
Registered: November 2005
Junior Member
Hi, could u advise me on the following?
There are 2 sites
1st one has someone data source
2nd owns Oracle Database
comm. channel is not great

I'm looking for a kind of software channel with api, meaning that data is put in at the 1st site and pulled out at the 2nd site and then put into Oracle Db

For instance if we had oracle database installed on the 2nd site we would use adv. replication or Oracle Streams. But what to do if we don't have oracle db on the 2nd site?

Has Oracle AS/Integration such technologies?
Re: Oracle AS/Integration [message #146664 is a reply to message #146278] Fri, 11 November 2005 19:28 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
The site not having Oracle could still have an Oracle client. Using that, it could insert/extract data from Oracle.

From pl/sql, you could use UTL_TCP to FTP a file or you could use UTL_HTTP to suck a text or HTML file into Oracle from a remote web server.
Previous Topic: How to avoid listing of plsql informations on internet
Next Topic: 9iAS known issues
Goto Forum:

Current Time: Wed Nov 25 13:56:36 CST 2020