Exec StoreProcedure with OUT parameter in a class library

[beffes]

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]

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!

[Shalex]

Could you please send us test projects with the corresponding DDL/DML script to reproduce the issue in our environment?