id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
329	Error in retrieving Oracle Integer data	Christian Paz	apalonso	"Hello,

I got unexact response when running:

Set dbNS=DBTable(""select A, B from  TESTORA"");

where TESTORA was created with the these sentences (Oracle 9i):
////////////////////////////////////////////
create table TestOra (
a integer,
b VARCHAR2(2)
)
insert into TestOra values(1, 'bl')
insert into TestOra values(0, 'b3')
insert into TestOra values(32, 'b2')
////////////////////////////////////////////

another strange thing is that when running from Tol Console (tol -d) it gives 
correct results: 
[[  [[  1.000000, ""bl"" ]] , [[  0.000000, ""b3"" ]] , [[  32.000000, ""b2"" ]]  ]]

as well as when running from BayesSQL (inside TolBase)

instead of ([[  [[  0.000000, ""bl"" ]] , [[  0.000000, ""b3"" ]] , [[  
0.000000, ""b2"" ]]  ]]) which I get when running from TolBase. Maybe it is because 
of the use of another tolodbc library from tol, but I don't know exactly how to 
validate this.

thanks,
Christian"	defect	closed	normal		Database	head	normal	fixed