Opened 19 years ago
Last modified 16 years ago
#329 closed defect
Error in retrieving Oracle Integer data — at Initial Version
Reported by: | Christian Paz | Owned by: | Jorge |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | Database | Version: | head |
Severity: | normal | Keywords: | |
Cc: |
Description
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