Problem with Oracle using Multiple Packages.

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

Problem with Oracle using Multiple Packages.

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 >> Problem with Oracle using Multiple Packages.

Page: [1]

Message

<< Older Topic Newer Topic >>

Problem with Oracle using Multiple Packages. - 14 July 2005

mpdolan

Posts: 2
Score: 0
Joined: 15 June 2005
Status: offline

I have set up a send/receive port that makes two DBMS_ALERT calls. DBMS_ALERT.Register, and DBMS_ALERT.WaitOne/DBMS_ALERT.WaitAny (both return in much the same way). My problem is that when the send port is envoked I am receiving a System.InvalidCastException.
DBMS_ALERT.Register has one parameter that is a varchar2. this part of the procedure works. I see it register for the alert. My problem I think is in the next procedure. the DBMS_ALERT.WaitOne. There are four parameters 2 out and 2 in. the in parameters are the name of the alert I am waiting for which is a varchar2, and the timeout which is a NUMBER type. the out parameters are the message, a varchar2, and the status of the message a number(38). I think that the problem is with the numbers, but every type that I use in XML is of no use. the operations are created with the number fields as decimals. I have also tried ints, and will be attempting doubles. The full exception message that I receive is below, but doesn't seem to be of much assistance.
Thanks in advance for any help.

Event Type: Error
Event Source: BizTalk Utilities Adapter for Databases Transmitter
Event Category: None
Event ID: 0
Date:  7/13/2005
Time:  5:06:54 PM
User:  N/A
Computer: BIZTALK-DEVEL
Description:
BTSUtils.Core.EnterpriseInstrumentation.Schema.ErrorMessageEvent
{
String Message = "An Exception occurred attempting to submit a Batch of Messages to the Database Transport.
System.InvalidCastException Specified cast is not valid."
Exception InnerException = {
     String HelpLink = ""
     String Message = ""
     String Source = ""
     String StackTrace = ""
     String TargetSite = ""
}
String ErrorCode = ""
Int32 Severity = 0
Int32 ProcessID = 2380
String ProcessName = "C:\PROGRA~1\MICROS~4\BTSNTSvc.exe"
String ThreadName = ""
ComPlusInfo ComPlus = {
     String ActivityID = ""
     String ApplicationID = ""
     String TransactionID = ""
     String DirectCaller = ""
     String OriginalCaller = ""
}
WindowsSecurityInfo WindowsSecurity = {
     String CurrentAccountName = "BIZTALK-DEVEL\BTUser"
     String ProcessAccountName = "BUILTIN\Administrators"
}
ManagedSecurityInfo ManagedSecurity = {
     String IdentityName = ""
     String AuthenticationType = ""
     Boolean IsAuthenticated = False
}
String StackTrace = " at BTSUtils.Core.Adapters.EnterpriseInstrumentation.Helper.Error(EventSource EventSource, Exception Exception, String Message)
at BTSUtils.Adapters.Databases.Transmit.Batch.SendMessages(IEnumerable Enumerator)
at BTSUtils.Core.Adapters.Transmit.Batch.Asynchronous.Batch.Base.Done(IBTDTCCommitConfirm commitConfirm)"
String EventSourceInstance = "9144580a-ea19-4d40-86c8-16fc2183a81c"
String EventSourceName = "BizTalk Utilities Adapter for Databases Transmitter"
Int64 EventSequenceNumber = 4
String EventSchemaVersion = "2.0.102.0"
DateTime TimeStamp = 7/13/2005 5:06:54 PM
String AppDomainName = "DefaultDomain"
String MachineName = "BIZTALK-DEVEL"
String RootRequestName = ""
String RootRequestInstance = ""
String RequestInstance = ""
String RequestName = ""
Int64 RequestSequenceNumber = 0
Int32 EventLogEntryTypeID = 1
}
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.