serious trouble with Oradirect 3.01

nerVouz · 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 · 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 · 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 · 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 · 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 · 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.

Devart Forums

serious trouble with Oradirect 3.01

serious trouble with Oradirect 3.01

trunction of characters also in oraDirect 3.0 or not