Call Oracle Function using BizTalk Utilities Adapter

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

Call Oracle Function using BizTalk Utilities Adapter

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 >> Call Oracle Function using BizTalk Utilities Adapter

Page: [1]

Message

<< Older Topic Newer Topic >>

Call Oracle Function using BizTalk Utilities Adapter - 12 March 2008

tomtom

Posts: 13
Score: 0
Joined: 2 February 2007
Status: offline

Hi all:

Can I call an Oracle function that performs an update and returns a status code using the BizTalk Utilities Adapter for Databases from a Send Port? I didn't see an option for Function in the wizard when I try to generate the schema using this adapter.

Thanks in advance!

Tom

Post #: 1

RE: Call Oracle Function using BizTalk Utilities Adapter - 3 April 2008

Pieter

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

You can call a function, you will need to mask it as a procedure. The return status code will not be handled though, you will need to use a REF CURSOR for this.

_____________________________

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

(in reply to tomtom)

Post #: 2