OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Oracle AS/Integration

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle AS/Integration [message #146278]

Wed, 09 November 2005 12:35

Intr
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?

Report message to a moderator

Re: Oracle AS/Integration [message #146664 is a reply to message #146278]

Fri, 11 November 2005 19:28

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.

Report message to a moderator

Previous Topic:	How to avoid listing of plsql informations on internet
Next Topic:	9iAS known issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 20:20:08 CDT 2025