ETL and Data Integration tools - Modern ETL software for everyone

I've been impressed with Database Browser so far, but seem to have hit a show-stopper for our Oracle databases. All of our tables have a 16 digit numeric field that is used to log the exact time of the write, but when trying to read any of the tables with the Database Browser, the following error is raised:
Overflow while converting variant of type (Decimal) into type (Currency)

Not sure why it is trying to convert like this (although a 16 digit currency value would be nice to see on a bank statement! )

I have had a look through all the connection/option settings, and can't find any settings that can be changed.

Any pointers/fixes would be most welcome.

Can you post your table creation script here please

Which version have you got?

Peter

I'm using the latest Portable version.

The tables are auto-created by the 4GL tool that is used to code our system. The only issue is reading the DTIME entries (verified by running "SELECT DTIME FROM TABLE1;", which returned the error if any rows are found).
to be honest, it looks like the browser is trying to guess the data type, and getting it wrong.

The table definition is as follows:
Name Null? Type
------------------------------- -------- ----------------------------
DTIME NOT NULL NUMBER(16)
REFNUM NOT NULL NUMBER(10)
PRIRTY NOT NULL NUMBER(2)
RECTYP NOT NULL VARCHAR2(1)
REQTME NOT NULL NUMBER(8)
FILREF NOT NULL NUMBER(4)
EFVDTE NOT NULL NUMBER(5)
ONLIND NOT NULL VARCHAR2(1)
RTYCNT NOT NULL NUMBER(2)
REQSTN NOT NULL VARCHAR2(17)
FILPOS NOT NULL NUMBER(6)
TRN_PR NOT NULL NUMBER(3)

Can you give this one a try please

www.dbsoftlab.com/dmdocuments/DatabaseBr...2.11_English.paf.exe

Peter

Works like a charm!

Out of interest, what was the cause of the attempt to convert?

We have changed the way of connecting to Oracle

It used to be Ole DB,
Nowdays we use direct connection

Mike