Returnvalue problem with ExecProc

Returnvalue problem with ExecProc

Postby 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
TobKim
 
Posts: 2
Joined: Wed 06 Dec 2006 11:12
Location: Sweden

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
TobKim
 
Posts: 2
Joined: Wed 06 Dec 2006 11:12
Location: Sweden

Postby Alexey » Fri 08 Dec 2006 11:06

We requested small test project to reproduce the problem, but received just a plain text.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle