I’ve migrated an interface from BizTalk 2006 R2 to BizTalk 2010. My interface polls data from Oracle table and calls a DB2 package from a helper class which
is invoked from an Orchestration.
Code of helper class is fairly simple which invokes a DB2 package by passing data as parameters:
Dim Conn As New MsHostFileClient.HostFileConnection
Dim Cmd As MsHostFileClient.HostFileCommand
Dim Result As String
Try
Conn.ConnectionString = “DB2_Connection_String”
Conn.Open()
Cmd = New MsHostFileClient.HostFileCommand(Conn)
Cmd.CommandType = CommandType.Text
Cmd.CommandText = "EXEC 'CALL PGM(TEMP_DEV/RC_NUM) PARM(PARAM1 RARAM2)'"
Result = Cmd.ExecuteScalar
Exception ex
Throw ex
End Try
The connection is opened properly DB2 package call is also invoked BUT the result returned by the package is a garbage value like
ကːĀ̒䤑
in BizTalk2010 while it returns desired value in BizTalk2006.
How can I get proper value instead of garbage in this scenario?
