Devart Forums

beffes

Yes, is there any documentation on how to implement this Instance Store?

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!

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

Hi have the same problem (latest version installed )...

Code: Select all

DataContext.Designer.cs

/// 
        /// There are no comments for Getfornecedores in the schema.
        /// 
        [Function(Name=@"TEST.PK_TEST.GETFORNECEDORES")]
        public System.Int32 Getfornecedores([Parameter(Name="ID_TIPO", DbType="VARCHAR2")] string IdTipo, [Parameter(Name="PAIS", DbType="VARCHAR2")] string Pais, [Parameter(Name="LOCALIDADE", DbType="NUMBER")] System.Nullable Localidade)
        {
            IExecuteResult _GetfornecedoresResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), IdTipo, Pais, Localidade);
            return ((System.Int32)(_GetfornecedoresResult.ReturnValue));
        }

is returning a INT32 instead of a Cursor

Code: Select all

(here is a part of the package)
...
TYPE csGetResultSet is REF CURSOR;
...
PROCEDURE GetFornecedores( id_tipo VARCHAR2, pais VARCHAR2, localidade NUMBER, resultado OUT csGetResultSet)

beffes

Hi,

Is there any news about this subject?
I was looking for that solution so that I can bind my oracle db to the workflow persistence.

Greetings,
Bruno

Devart Forums

Search found 5 matches

Exec StoreProcedure with OUT parameter in a class library