Exec StoreProcedure with OUT parameter in a class library

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
beffes
Posts: 5
Joined: Mon 31 Jan 2011 09:21

Exec StoreProcedure with OUT parameter in a class library

Post by 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

Post by 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!

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Post by 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?

Post Reply