One of our developers at our site is encountering a problem with the format of numerical data returned from SQL passthrough. Two columns are defined as numeric in Oracle. One is 15,4 - the other is 13,4. However, in the temp file, the master identifies the columns as D20.2.

This is causing problems on the user front.

Is there a setting somewhere that we're missing?

Ken

Ken,
I ran into this problem too. I was able to get around it by changing some setting in the WF Server. I made the following changes in the edasprof.prf file:

ENGINE SQLORA SET CONVERSION FLOAT PRECISION 20 7
ENGINE SQLORA SET CONVERSION DECIMAL PRECISION 20 7

What this will do is turn all Oracle Numbers that don't have a defined size to D20.7 or P20.7.

I think in WF 5.3.x if you click on the Data Adapter you can make these changes to a specific adapter.

Also when doing a SQL-passthrough you don't use the .mas file.

This message has been edited. Last edited by: reFOCUSing,

Thanks C.

Worked out great.

Ken

No problem. Just be careful if you are doing calculations in the pass-through as WebFOCUS will convert those values as if they are an Oracle Number. This will result in a D20.7 or P20.7 based on the example I gave you.