6.60 - package procedures without parameters do not work

6.60 - package procedures without parameters do not work

Postby 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]
JomKippur
 
Posts: 17
Joined: Wed 31 Aug 2011 15:46

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1954
Joined: Wed 02 Nov 2011 09:44

Postby 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
JomKippur
 
Posts: 17
Joined: Wed 31 Aug 2011 15:46

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1954
Joined: Wed 02 Nov 2011 09:44

Postby JomKippur » Wed 01 Feb 2012 15:48

Does dotC. 6.70 contain bug fix?

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

Postby 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: 1954
Joined: Wed 02 Nov 2011 09:44

Postby 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
Pinturiccio
Devart Team
 
Posts: 1954
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle