Returning master/detail information from Oracle to 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

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

Returning master/detail information from Oracle to BizTalk

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 >> Returning master/detail information from Oracle to BizTalk

Page: [1]

Message

<< Older Topic Newer Topic >>

Returning master/detail information from Oracle to BizTalk - 5 September 2006

sunedh

Posts: 9
Score: 0
Joined: 29 August 2006
Status: offline

Hi all,
I’m looking for some best practices when returning mater/detail information from Oracle to BizTalk, i.e. an Order with multiple OrderLines.
I’m currently denormalizing the data similar to what it outlined below:
Order1                  OrderLine1
Order1                  OrderLine2
Order2                  OrderLine1
Order2                  OrderLine2
Order2                  OrderLine3
This denormalized data I insert into a temporary table on which I open a sys_refcursor defined as an output parameter.
In the simple example above this works okay, however, when the data is just a little more complex (i.e. have more than just two levels) is gets really cumbersome.
Is there a recommended way to return master/detail information or is this the way I have to do it?
Best regards,
Sune