Exec StoreProcedure with OUT parameter in a class library
Posted: 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 {}
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
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);
Is there any modification to be made to the package or code to call it inside a Workflow project?
Need more information?
Thanks,
BeFFes