Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OCIAttrGet: Getting the 'scale' information of a column
Hi folks,
I have a SQL table with a column 'UnitPrice' defined as "number(9,2) default
0.0"
In my application I have a query which does a select of some columns. One of
the columns is 'UnitPrice'. I am doing a OCIStmtExecute with the
OCI_DESCRIBE_ONLY option. Then I do a OCIParamGet to get the descriptor for
each column. On this descriptor, I do a bunch of OCIAttrGet's to get the
attributes(data type, name, scale etc.) of each column.
The problem is that on the column 'UnitPrice', OCIAttrGet is returning a
scale of 0 instead of 2.
Is there anybody who has encountered this problem? Is there a solution or a
work-around for this problem?
Any information regarding this problem is greatly appreciated.
thanks.
reddy rachamallu
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 18:23:02 CDT