This OracleTransaction has completed; it is no longer usable

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

This OracleTransaction has completed; it is no longer usable

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 >> This OracleTransaction has completed; it is no longer usable

Page: [1]

Message

<< Older Topic Newer Topic >>

This OracleTransaction has completed; it is no longer u... - 29 August 2006

sunedh

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

I have created a Oracle procedure which has a sys_refcursor output parameter. I have also created a BizTalk Receive Port that calls this procedure. However I keep receiving the following error in the Event Log:

BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception Occurred attempting to retrieve Messages from the Uri 'database://Microsoft .NET Data Provider for Oracle Version 2.0.0/DistributionRequests/DistributionRequest'
System.InvalidOperationException
This OracleTransaction has completed; it is no longer usable."
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}

Has anyone received this error before and is able to help me in the right direction? I must admit that I am no expert in Oracle procedure, but I have managed to call the procedure in a BizTalk Request/Response Send Port.

Also I would like to know if there are any limits to the number of rows that can be returned in the sys_refcursor?

Regards,
Sune

Post #: 1

RE: This OracleTransaction has completed; it is no long... - 30 August 2006

Pieter

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

Would it be possible to export the bindings for the Recie Port and mail it through to us at support@theenablergroup.com.

It would also be helpfull if you could mail us the Stored Proc Script as well.

Also is this a 64-bit environment?

_____________________________

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

(in reply to sunedh)

Post #: 2

RE: This OracleTransaction has completed; it is no long... - 30 August 2006

Pieter

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

What is your Transaction Property set to on the Recieve Port?

_____________________________

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

(in reply to Pieter)

Post #: 3