Update / Insert

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

Update / Insert

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 >> Update / Insert

Page: [1]

Message

<< Older Topic Newer Topic >>

Update / Insert - 30 September 2004

bjansson

Posts: 1
Score: 0
Joined: 30 September 2004
Status: offline

I have a XML document with items that I want to store in my Oracle DB. What is the recommended way to do a update (if the item exists) or insert (if the item does not exists) with the database adapter?

Best regards
Björn Jansson

Post #: 1

RE: Update / Insert - 30 September 2004

Pieter

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

Hallo. You have 2 options for doing this.

You can use a Stored Procedure to perform the Insert/Update Lgogic. But the limitations on Parameters may cause an issue with your XML Document. The other option would be to first do a select from the Orchestration, get a count of the returned records and then either perform the Insert or Update.

Cheers

_____________________________

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

(in reply to bjansson)

Post #: 2