TD51 SP2 Unable To Fetch Data From Oracle Table

[Sunil]

I am running TD51 deployments inhouse and find most of Time TD unable to fetch data from Oracle Table. I am not able to figure out exact problem but certainly this problem is there. Please take seriously issue. Sometimes TD failed to write data in Oracle Table column .


Sunil

[caa]

We have no problems fetching data. Can you provide a repro case so that we can debug this problem?

[Sunil]

I am trying to repro this case but i am not able to do so but certainly major problem. My client has lost data from various tables. I can give one clue , problem may ibe n while data capture or update in long string datatype.

Please take this issue very very seriously .

Sunil

[caa]

I would certainly like to see a repro case so that we can fix it.

Our QA tests fetch and store data to long strings -- those tests pass. So clearly we're not doing what you're doing.

[Sunil]

These are following clues where i would like to have your attention.
1. Extract data from Oracle long string datatype to Table windows, sometime dropped.
2. On SAM_ANyEdit sometime works fine and sometime failed.
3. SqlExists failed.
4. upper or lower function failing sometimes.
( in that case you have to come out from your application or restart your PC. Mostly when you are trying to logged in application using normal User Login / User Password. )

( I am working with 10g Server and 9i clients ) .

Sunil

[caa]

Are you using a 9.2 client or better?

[Sunil]

I am using 9.2.0.1.0 as client and Server is 10.2.0.1.0 . Please let me know if anything more required.

Sunil

[caa]

A repro case, please!

[Sunil]

here I have got clue and i wil send you repro for the same, meanwhile if you would like see at your end then this is clue.

Fetch using SqlImmediate from Oracle Table having long string data type into Multiline Text. This fetch fails sometimes not always. I am working at my end and let you know exact repro.

Sunil

[Jean-Marc Gemperle]

Hi,

I have seen that issue with Sunil directly. The issue is related to a query using SqlImmediate() with an into clause of an ORACLE LONG column (TEXT) that do not return a values ( other columns are fine) in a random fashion. It does not seems to be related to data ( but must be in a way ) and using SqlPrepareAndExecute() did not help, as well as attempting to use SqlSetLongBindDataType() to force the long to be seen as TEXT (it is anyway per default) or SqlSetInmessage() as a shot in the dark did not help. Also using a variable as opposed to a multi line edit field did not help.

So currently figuring out how to reproduce that issue. I belive ORACLE LONG DATA TYPE are deprecated and CLOB should be used instead...now don't know if that would help and it should be ok with LONG anyway. Client is 9.02 against 10g

JM