Biztalk Adapter for Oracle (trigger alternative)

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Biztalk Adapter for Oracle (trigger alternative)

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Biztalk Adapter for Oracle (trigger alternative)

Page: [1]

Message

<< Older Topic Newer Topic >>

Biztalk Adapter for Oracle (trigger alternative) - 5 January 2007

shamir.ali

Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline

Hi,

I have tried to implement the sample tutorial which comes with the utilitiies. 'OraclePipe' to be exact, now the issue is that the organization that i am engaged with dont allow me to send any messages through pipes.... as in we are to use a stmt in the trigger creation like :

dbms_pipe.send_message('bts_pipe');

The DBA doesnt allow me to do this, So, could any one please suggest me an alternative to the sending of a new entry/record's URN/Number.

Thanks.

Post #: 1

RE: Biztalk Adapter for Oracle (trigger alternative) - 6 January 2007

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

I would recommend a polling approach then. Basically the trigger will write a new record to a table once the record is created. You will need a flag as well to tell you if the record was processed.

You will need to poll this table with an RL and look for records that are unprocessed. Once you pass the records back you will need mark them as being processed. So you will need a stored procedure here to do this.

Because the DB Adapter is fully transactional the processed flag will only stick if BTS processes the records successfully.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to shamir.ali)

Post #: 2