Exec StoreProcedure with OUT parameter in a class library

Exec StoreProcedure with OUT parameter in a class library

Postby beffes » Mon 04 Apr 2011 13:43

Hi,

I'm developing a Worflow in Workflow Foundation 4, and I'm having trouble with a store procedure.

I have a solution with 2 projects( Workflow, Activities).

In the Activities I have a package created via Oracle Package Wizard. When I call the package the return value is always "" (empty), I debug the package and the value is empty/null {}

Code: Select all
OracleConnection oConn = new OracleConnection("Data Source=db; User=user1; Password=user1");
string result = "";
oConn.Open();
Pkcreateprocess createProcess = new PieapiPkcreateprocess();
createProcess.Connection = oConn;
createProcess.Createprocess("12345", out result);


but when I create a blank console project the package returns the expected result.

Is there any modification to be made to the package or code to call it inside a Workflow project?
Need more information?

Thanks,
BeFFes
beffes
 
Posts: 5
Joined: Mon 31 Jan 2011 09:21

Postby beffes » Tue 05 Apr 2011 07:51

I just found the problem...

there is an error in the store procedure, but is strange how with the same code the result is different!
beffes
 
Posts: 5
Joined: Mon 31 Jan 2011 09:21

Postby Shalex » Tue 05 Apr 2011 08:13

Could you please send us test projects with the corresponding DDL/DML script to reproduce the issue in our environment?
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle