Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
lqc1

Member
Registered:
Posts: 13
Reply with quote  #1 
I am trying to use OLEDB to connect to an Oracle database and execute a stored procedure with an output parameter.

As a first step, I am trying to trying to execute a SELECT statement,

try

{
    System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection("Provider=msdaora;Data Source=DBServer;User ID=User;Password=PWD");
    conn.Open();

    System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand()
    {
        CommandText = "SELECT COUNT(*) FROM EFOLDER",
        Connection = conn,
        CommandType = CommandType.Text,
    };
     

    cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
    Mstm.WriteToLog(ex.Message,"",Severity.Error);
}

but I am getting the error message: The Transaction Manager is not available.  (Exception from HRESULT: 0x8004D01B)

Does anyone have experience doing this in MBPM 9.2 designer?

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
I am pretty certain stored proc output parameters are not supported
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
lqc1

Member
Registered:
Posts: 13
Reply with quote  #3 
Jerome:

Output parameters are supported for OLEDB in Metastorm.  The error is caused by the DTC.  Unenlisted the DTC in the OLEDB connection and the stored procedure works as usual.

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
Great, thanks for that.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!