serious trouble with Oradirect 3.01

serious trouble with Oradirect 3.01

Postby 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.
nerVouz
 
Posts: 2
Joined: Fri 15 Jul 2005 04:55

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

trunction of characters also in oraDirect 3.0 or not

Postby 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???
sak
 

Postby Paul » Mon 18 Jul 2005 06:21

This is problem of OraDirect .NET 3.01.1 only.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby 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
sak
 

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby 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
darkbouba
 

Postby 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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for Oracle