Biztalk and Oracle

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 and Oracle

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 2002 Utilities and Adapters >> Biztalk and Oracle

Page: [1]

Message

<< Older Topic Newer Topic >>

Biztalk and Oracle - 20 July 2004

lnthach

Posts: 2
Score: 0
Joined: 19 July 2004
Status: offline

I try to make an extracting from table of Oracle database to another table that is same the database.
I would like to try using store procedure to get data from the table.

Question) Is it need to write store procedure return xml format? If it's need, how I write store procedure?

Post #: 1

RE: Biztalk and Oracle - 20 July 2004

Pieter

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

Hallo.

My name is Pieter van der Merwe.

I am not too sure what the scenario is. Do you want to execute the Stored Procedure with A Receive Function or the Oracle Command AIC.

The Stored Procedure does not need to return XML Data. This is the job of the Adapter to retrieve the Data as XML. You can either return a Cursor or Select the result set from the Stored Procedure.

I'm not too sure if you want to do this in BizTalk Server 2002 or 2004. The latest beta of the 2004 Adapter is completed now and can be downloaded from the TopXml site. It is a huge improvement on the 2002 Adapter.

Let me know if you require any further assistance.

Cheers

_____________________________

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

(in reply to lnthach)

Post #: 2

RE: Biztalk and Oracle - 20 July 2004

lnthach

Posts: 2
Score: 0
Joined: 19 July 2004
Status: offline

Thank Pieter for your reply.
I need your help and everybody more:

1) In Biztalk Server 2004, the job of the Adapter to retrieve the Data as XML, it is still true?

2) I want to try the scenario:
An Oracle Database "D" have 2 table A(A1, A2) and B(B1,B2) with 1-1 relationship A.A1 = B.B1.
Procedure P will make a join of A va B and return XML format that include (A1,A2,B2).

I want use XML format result of Procedure P for input schema to extract a new table C.

Can you help me write Procedure P?

Sincerely,

Thach

(in reply to Pieter)

Post #: 3

RE: Biztalk and Oracle - 21 July 2004

Pieter

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

Hallo. I would recommend that you use a ref cursor that returns the reult from the Stored Procedure.

Unfortunately we do not write Stored Procedures.

We do have an extremely competent team of Consultants who can do this for you though.

Let us know if you have any further issues/questions.

Cheers

_____________________________

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

(in reply to lnthach)

Post #: 4