Update / Insert (Full Version)

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters



Message

bjansson -> Update / Insert (30 September 2004)

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



Pieter -> RE: Update / Insert (30 September 2004)

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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.171875