id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
349	Problems selecting integral values from oracle database.	jimarin	Jorge	"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."	defect	assigned	lowest		DataBase	head	blocker			Christian Paz