Procedure issue with 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

Procedure issue with 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 >> Procedure issue with biztalk

Page: [1]

Message

<< Older Topic Newer Topic >>

Procedure issue with biztalk - 22 January 2008

Siva

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

Hi,
I am trying to retrieve data from oracle table using BizTalk oracle adapter. I have the quary in package. I have to use package for this project.
I could not create Oracle schema from "add Generate Items" wizard using package. When i run the "add generate items" for the package, using the receive port that connect to the db, it is creating object schema and orchestration only, not procedure schema.
How can I use procedure(package) to retrieve data from Oracle database in biztalk 2006 R 2?
--
Thank you,
Siva

Post #: 1

RE: Procedure issue with biztalk - 22 January 2008

Pieter

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

You have to prefix te procedure name with the package. i.e. <pckage>.<procedure>

_____________________________

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

(in reply to Siva)

Post #: 2

RE: Procedure issue with biztalk - 23 January 2008

Siva

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

Thank you Pieter,
Can we use the cursor as procedure parameter? I notcied that when I use cursor as procedure paramter, "add generate items" wizard could not create schema. How can I handle this case?

(in reply to Pieter)

Post #: 3

RE: Procedure issue with biztalk - 29 January 2008

Pieter

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

You will need to use a REF CURSOR. All ADO.NET technologies only support this with Oracle.

_____________________________

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

(in reply to Siva)

Post #: 4

RE: Procedure issue with biztalk - 29 January 2008

Siva

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

Thank you for your help.
Since I am new to biztalk, I am not sure how to use ADO.NET to retreive multiple rows from oracle db using oracle procedure in biztalk. I couldnt find sample or tutorial online neither. Do you know any?

(in reply to Pieter)

Post #: 5

RE: Procedure issue with biztalk - 30 January 2008

Pieter

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

Which Adapter are you using?

_____________________________

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

(in reply to Siva)

Post #: 6

RE: Procedure issue with biztalk - 30 January 2008

Siva

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

I am using Oracle Adater. I want to retrieve multiple records from oracle DB using oracle package/procedure.

(in reply to Pieter)

Post #: 7