6.60 - package procedures without parameters do not work

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
JomKippur
Posts: 17
Joined: Wed 31 Aug 2011 15:46

6.60 - package procedures without parameters do not work

Post by JomKippur » Thu 26 Jan 2012 00:23

Hi,

Running this:

Code: Select all


			OracleUtils.OracleClientCompatible = true;
			OracleConnection oc = new OracleConnection();
			oc.ConnectionString = "pooling = false";
			oc.Direct = true;
			oc.Unicode = true;
			oc.AutoCommit = false;
			oc.Server = "10.60.1.183";
			oc.Sid = "XE";
			oc.UserId = "user";
			oc.Password = "*****";
			oc.Open();

			OracleCommand o2 = oc.CreateCommand();
			o2.CommandText = "Test.T1";
			o2.CommandType = CommandType.StoredProcedure;
			o2.Prepare();

			var r = o2.ExecuteScalar();

Code: Select all

create or replace
PACKAGE Test IS
	procedure T1;
	procedure T2(a in number);
END Test;

create or replace
PACKAGE body Test IS
	procedure T1 is begin null; end;
	procedure T2(a in number) is begin null; end;
END Test;
I got this (calling Prepare method):
ORA-03115 unsupported network datatype or representation []

:shock:

Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Greetings
JK[/code]

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Thu 26 Jan 2012 13:01

We have reproduced the issue. We will investigate it and notify you about results as soon as possible.
This issue occurs only in direct mode. As a workaround, you can try using oci mode.

JomKippur
Posts: 17
Joined: Wed 31 Aug 2011 15:46

Post by JomKippur » Thu 26 Jan 2012 13:13

Hi,
As a workaround, you can try using oci mode.
It's not possible. I'm waiting for fixing the bug.

Thanks,
JK

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Mon 30 Jan 2012 11:06

We have fixed the bug with OracleCommandBuilder.DeriveParameters method when executing procedure without parameters from package in Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

JomKippur
Posts: 17
Joined: Wed 31 Aug 2011 15:46

Post by JomKippur » Wed 01 Feb 2012 15:48

Does dotC. 6.70 contain bug fix?

JK

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Thu 02 Feb 2012 14:51

No, dotConnect for Oracle 6.70.293 does not contain the fix of this bug. It will be available in the next public build of dotConnect for Oracle.

Pinturiccio
Devart Team
Posts: 2141
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Fri 10 Feb 2012 12:36

The new build of dotConnect for Oracle 6.70.302 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23367

Post Reply