Ora9i ORA-03127 problem

[alexjunq]

Hi,

I have a customer that's presenting some problems after upgrade their database to Oracle 9i (9.0.1.0.0) for Linux.

The application was developed using Delphi4, QR 3.0.3, DOA 3.3.1 and Client ORA 8.0.5 on Win98 clients

The following steps are required to reproduce their error: they have a report that prints out some information based on database query; it's ok since only preview or print the report. But if you select preview function and then, using it's native print button the strange behaviour sets. After that, any query against database generate the EInvalidAccess exception leading to an ORA-03127 error.

We've already done the following tries to solve their problem:

1. change Oracle client to something closer to database version: 8.1.7 and 9.2.0.1. Both still present the same behaviour.

2. accordingly to other messages from this group we changed the DOA library to it's most recent version - 3.4.6; nothing happens

3. we've looked back in application to verify that's no multi-thread problem could be causing the troubles ... none of then was found. We've forcelly tried to set default values to don't use multi-thread but nothing happens too.

Well, if some of you have any other idea we'll be glad.

Thanks in advance

Alexandre

 

[Marco Kalter]

Could it be that your database is created with a multi byte character set, and that TOracleSession.BytesPerCharacter = bc1Byte? If so, could you set it to bcAutoDetect and try again?

------------------
Marco Kalter
Allround Automations

 

[alexjunq]

Hi Marco,

I checked with my customer but their database is running on common charset (WE8ISO8859P9)...

Any other idea?

Thanks

Alexandre Junqueira

 

[Marco Kalter]

Can you try bcAutoDetect, despite of what your customer is saying? I only have one other ORA-03127 report in my records, and it was related to a multi-byte character set.

------------------
Marco Kalter
Allround Automations