Returnvalue problem with ExecProc

TobKim · Post by **TobKim** » Wed 06 Dec 2006 11:29

Hi,
I have a problem with the returnvalue from the function ExecProc in the OraclePackage.

I have created a package in Oracle with two procedures, one that loads a pipe with a integer value and one that reads a integer value from the pipe.

I have also a program written in C# that uses CoreLab Oracle.
in the C#-program I do this:
"
OracleConnection oraConn;
oraConn = new OracleConnection();
OraclePackage packagePipe = new OraclePackage();
strConnect = "User id= BASDATA;Password= BASDATA;Server= PUCCINI";
oraConn.ConnectionString = strConnect;
oraConn.Open();

packagePipe.Connection = oraConn;
packagePipe.PackageName = "pipe";
object objReturnValue = packagePipe.ExecProc("read_pipe");
"
The problem I have is that the variable objReturnValue never seems to get any value. The function call is working, becaus the pipe is empty after calling the function.

Is there something I have to do in my Oracle package or is it someting else.

Tanks for all help in advance.

TobKim

Alexey · Post by **Alexey** » Wed 06 Dec 2006 12:42

We cannot reproduce the problem. Send us small test project if possible to reproduce the problem; include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.

TobKim · Post by **TobKim** » Fri 08 Dec 2006 10:16

Hello,

I'm just wondering if my emails you requested have arrived ok and if you need anything else?

I hope it’s not a serious problem and that you can fix it or tell me what I did wrong.

Thanks for all your help!

/TobKim

Alexey · Post by **Alexey** » Fri 08 Dec 2006 11:06

We requested small test project to reproduce the problem, but received just a plain text.

Alexey · Post by **Alexey** » Tue 12 Dec 2006 14:36

We have investigated your project.
OUT parameters are not returned using ExecProc() function. Only ReturnValue can be returned.