ORA-03120 when Selecting records in DB

Hi

I can connect to the Database with no problem

I am accessing the DB with the System.Data.OracleClient.OracleDataReader  object in VB.NET

When i try to read a single record i got the 03120-two task conversion routine.

this is supposed to return me one single value (i.e. "F")

I read it me be NLS_LANG not correct, but i have the same valeu that my mate (CANADIAN FRENCH_CANADA.WE8MSWIN1252) in the NLS_LANG registry key under the Oracle HOme Key (10g)

I tried to put that in environnement variable or une der the Oracle root in registry but that cause TNS-0.1254 unable to resolve service name

tks

polycorjspAsked:
Who is Participating?
 
actonwangConnect With a Mentor Commented:
>>ORA-03106: fatal two-task communication protocol error on a particular table.

     try to reconnect. it might be timeout.
0
 
jrb1Commented:
Hi polycorjsp,

I don't think it shoiuld be related to NLS_LANG.  What type of data are you trying to read?  Are you sure there isn't a conversion problem?

Regards,
John
0
 
sathyagiriCommented:
Are you trying to load a CLOB column or is it just a regular column?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
actonwangCommented:
0
 
MohanKNairCommented:
Check the Oracle server and Oracle client versions? If they are different verify whether it is compatible.
0
 
polycorjspAuthor Commented:
I am trying to read a varchar2 field.

This is the first thing i am trying to acces from the database

How can i know the Server version ?

my client is 10g.
0
 
MohanKNairCommented:
select * from v$version;
0
 
actonwangCommented:
select version from v$instance;
0
 
polycorjspAuthor Commented:
i have the same client / server version

This is working for my mate who is using the same client that i have. connecting to the same database

This is working with SQL+ ou TOAD.

Both ASP.NET & VB.NET cause this error.

Could this be related toi regional setting ? i hope not.

i have the feeling this is a character trasnlation error.

tks again
0
 
actonwangCommented:
ORA-03120:two-task conversion routine:integer overflow

Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in user application.

Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767
0
 
polycorjspAuthor Commented:
Hi

i change the table i want ot access and got a different error message ?!?!?!?!?

this has to be a joke.

ORA-03106: fatal two-task communication protocol error on a particular table.

tnsnames ? sqlnet.ora ????


0
 
polycorjspAuthor Commented:
Here is a new clue

i can access any NUMBER or DATE column.

When i try to access Varchar2, i have the ora-03120

This is a NLS_LANG / Regional Settings / Trasnlation  mess.

How to fix this
0
 
polycorjspAuthor Commented:
GOT IT

This is the biggest fat joke in IT history

In the TNSNAMES.ORA remove all space, tab, carriage return on the conection string and, ALLELUILA !!!

http://php.mirrors.powertrip.co.za/manual/es/function.ocilogon.php

i think i'll be sick.....................
0
 
actonwangCommented:
What? really?

you need to make sure that you ONLY use net manager to manage your tnsnames.ora. never change it manually.


good to know.. I would be sick if I were you :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.