Devart Forums

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

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.

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

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

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