Oracle procedure for BizTalk

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

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

Oracle procedure for BizTalk

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

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Ask XML questions here] >> BizTalkers >> Oracle procedure for BizTalk

Page: [1]

Message

<< Older Topic Newer Topic >>

Oracle procedure for BizTalk - 11 December 2007

Siva

Posts: 102
Score: 0
Joined: 20 September 2006
Status: offline

Hi,
I am trying to write an oracle procedure to insert into a table using BizTalk 2006 Oracle adapter.
Do I need to add any special syntex in the oracle procedure? We have to add "XMLDATA" syntex for the MS SQL procedure. Do we have any smiller syntex for Oracle procedure?
If i want to add multiple rows in one iput file, what set up do i need to do on Oracle Adapter Schema? I remeber that we used to get "after, before" blocks for updategram. do we have to do smiller stuff for oracle adapter schema? if I have to, then how/where to add them?
I am just new to oracle, I never used procedure for SQL adapter before.

Thank you in advace,
Siva

Post #: 1

RE: Oracle procedure for BizTalk - 15 January 2008

Posts: 4
Score: 0
Joined: 15 January 2008
From: Egypt
Status: offline

Siva-
Check this tutorial , it will help you :
http://msdn2.microsoft.com/en-us/library/aa578617.aspx

_____________________________

Best regards,
Mohammad Yousri

http://mohammad-yousri.blogspot.com/

(in reply to Siva)

Post #: 2