Skip to main content

Using SmartObjects Service Tester to create SmartObjects from Oracle tables (right click, create smartobject).  When I look at the datatypes they are not what is set in the oracle table and I have to change them (i.e. Oracle datatype is a number and that field gets defined as a decimal (which has the default of 2 digits after the decimal point) have to open the smart object and change it to number).  Any way to have them come in as they are defined in Oracle?

Hi Bricot,

 

Saw this information.

 

The following Oracle Types are mapped to decimal in K2:
NUMBER, BINARY_FLOAT, BINARY_DOUBLE, FLOAT.

.NET does not have the same datatypes as Oracle. And to use it in the SmartObject Tester Tool and in code, these datatypes needs to be converted to the underlying .NET datatypes.

 

 

JK.

 


Reply