Problems selecting integral values from oracle database.

[jimarin]

Hi,

I have a database which is served by Oracle 9i.

In sadd table SetInput there is a field defined as INTEGER (or NUMBER(38) in
Oracle terms) called orderf.

I have introduced a line in that table that goes:

CODE ORDERF INHERITANCE SETINPUTFATHER DESCRIPTION
========================================
Pub_Si 1 N NULL Publicity

If I do:

Set DBTable(
"SELECT orderf FROM CNOSETINPUT;"
);

I get a 0 !!!!!!!!

Whereas if I do the same query by any other means (sql plus, sqltools, ...)

I get the 1 !!!!!

This is so bad that no operations against the Oracle database can be trusted.

jima

PS.
This error is very easy to reproduce.
This error does not take long to reproduce.
We urge for this error to be solved in the least amount of time possible.

[Víctor de Buen Remiro]

Hello

This error is "very" imposible to reproduce if you don't have any Oracle server to
ask your query, and take an eternity in this case.

I think it's a problem with new numerical data types in ODBC that are not revisited
in our ODBC to TOL connection software, but I don't known anything about ODBC,
so I can't resolve it.

However, I get similar errors with MySQL and I skip the problem with by casting to
standard types as double, or simply by adding 0.0E0 to forze casting more easily.
I hope it will run in this way.

Best regards

[danirus]

Hi,
In other case I can care about it. Please Jima, let me know.
Cheers.

[jimarin]

Well,

I think we should not forget platforms like Windows and Oracle.

A bug can be impossible to reproduce, but not seriously for the reasons mentioned.

Just my oppinion.

jima

[Christian Paz]

I saw and reported this error sometime ago (Bug 329).

About that time Jorge was working to solve this bug. We avoided this bug by making this "trick", replace for example:

select numeric_field from table1

with

select numeric_field+0 from table1

This returns the correct value for numeric_field.

Another tip: when calling from tol-console this error does not occur, i.e. the correct value is returned.