serious trouble with Oradirect 3.01

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
nerVouz
Posts: 2
Joined: Fri 15 Jul 2005 04:55

serious trouble with Oradirect 3.01

Post by nerVouz » Fri 15 Jul 2005 06:10

Hi,

I've found a serious problem with the new OraDirect 3.01 for .NET 1.1
in the standard an professional edition.

let's watch the table design

Code: Select all

Name          Null?               Type
CID             NOT NULL        VARCHAR2(10)
CNAME                           VARCHAR2(5)
CIDKAPITEL                      VARCHAR2(4)
CBEZEICHNUNG                    VARCHAR2(255)
CPS                             VARCHAR2(1)
CISTEINNAHME    NOT NULL        NUMBER(1)
CBEMERKUNGEN                    VARCHAR2(4000)

If I do a select from this table (using OraDirect) every field of type varchar
returns a value that length is reduced by 1.
In the pl-sql console the values are returned correctly

i.e. if the CIDKAPITEL is '0706' the returned value by OraDirect would be '070'

I just recognized that for the varchar type.

I really need your help with this issue.

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Fri 15 Jul 2005 07:09

We reproduced this problem and fixed it. This fix will be included in the next OraDirect .NET build.

sak

trunction of characters also in oraDirect 3.0 or not

Post by sak » Mon 18 Jul 2005 06:06

Does the specific problem i.e trunction of characters (present in oraDirect3.01) also present in oraDirect 3.0 or not???

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 18 Jul 2005 06:21

This is problem of OraDirect .NET 3.01.1 only.

sak

Post by sak » Sat 23 Jul 2005 11:05

I am using oraDirect.NET3.01 professional for .net framework 1.x with oracle 8i,9i,9i.2 and 10g. I recently have encountered two problems:
1) It truncates the varchar columns IF LENGTH OF COLUMN=NO OF CHARACTERS PRESENT IN THAT COLUMN”
EXAMPLE: if Column1 Varchar(6) contain value=’123456’ it will truncate the last character and return “12345” BUT if the same column contain value=’12345’ it wont truncate anything and return ‘12345’

2) When I try to fetch data from an oracle table “sys.table_privileges” (using system/manager ) it raise an error "NET: Unknown error 1".
When I look for the reason of error I found that it can fetch all the raws from that table if I truncate the last column, and it fetch nothing if I include the last column “created” having length “0” in 8i and no length defined in 9i and 10i(by default).
Regards SAK

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 25 Jul 2005 06:54

This problem is described above. We fixed it. Please wait for the next OraDirect .NET build this week.

darkbouba

Post by darkbouba » Thu 04 Aug 2005 08:05

I have the same problem but with the Mobile version of OraDirect ... who can help me ?? or is the bug fixed in the Mobile version ??

thx

darkbouba

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Thu 04 Aug 2005 11:00

We fixed these problems in OraDirect. NET 3.01.2 and in Mobile edition too.
Please download this version to solve the problem.

Post Reply