Page 1 of 1

serious trouble with Oradirect 3.01

Posted: Fri 15 Jul 2005 06:10
by nerVouz
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.

Posted: Fri 15 Jul 2005 07:09
by Paul
We reproduced this problem and fixed it. This fix will be included in the next OraDirect .NET build.

trunction of characters also in oraDirect 3.0 or not

Posted: Mon 18 Jul 2005 06:06
by sak
Does the specific problem i.e trunction of characters (present in oraDirect3.01) also present in oraDirect 3.0 or not???

Posted: Mon 18 Jul 2005 06:21
by Paul
This is problem of OraDirect .NET 3.01.1 only.

Posted: Sat 23 Jul 2005 11:05
by sak
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

Posted: Mon 25 Jul 2005 06:54
by Paul
This problem is described above. We fixed it. Please wait for the next OraDirect .NET build this week.

Posted: Thu 04 Aug 2005 08:05
by darkbouba
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

Posted: Thu 04 Aug 2005 11:00
by Oleg
We fixed these problems in OraDirect. NET 3.01.2 and in Mobile edition too.
Please download this version to solve the problem.