close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 20 years ago

Closed 17 years ago

#329 closed defect (fixed)

Error in retrieving Oracle Integer data

Reported by: Christian Paz Owned by: apalonso
Priority: normal Milestone:
Component: Database Version: head
Severity: normal Keywords:
Cc:

Description (last modified by 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

Change History (4)

comment:1 Changed 20 years ago by Jorge

Status: new → assigned

comment:2 Changed 17 years ago by Víctor de Buen Remiro

Component: Various → Database

comment:3 Changed 17 years ago by apalonso

Description: modified (diff)
Owner: changed from Jorge to apalonso
Status: assigned → accepted

comment:4 Changed 17 years ago by apalonso

Resolution: → fixed
Status: accepted → closed

Tested with tolbase 1.1.7, it seems to be fixed.

Note: See TracTickets for help on using tickets.