DCCoolBreeze
Programmer
I have a array of variables defined as 3-64-bit words or llValue[3] where
llValue is defined as a word64. I need to store this array in a NUMERIC
field in an Oracle table. I have tried defining a structure
struct ddd {
word64 llValue[3];
long lValue
char dtm[10];
} table_record;
then I attempted an insert
...(table_record& t)
{
EXEC SQL INSERT INTO TABLE VALUES t);
}
I am unable to store llValue into the NUMERIC field. I changed the
statement to
EXEC SQL INSERT INTO TABLE VALUES (222,:t.lValue,:t.dtm);
This works..therefore the problem seems to be with t.llValue
I understand that the NUMERIC field can hold upto 38 bytes so how do I load
the llValue array into the field??
llValue is defined as a word64. I need to store this array in a NUMERIC
field in an Oracle table. I have tried defining a structure
struct ddd {
word64 llValue[3];
long lValue
char dtm[10];
} table_record;
then I attempted an insert
...(table_record& t)
{
EXEC SQL INSERT INTO TABLE VALUES t);
}
I am unable to store llValue into the NUMERIC field. I changed the
statement to
EXEC SQL INSERT INTO TABLE VALUES (222,:t.lValue,:t.dtm);
This works..therefore the problem seems to be with t.llValue
I understand that the NUMERIC field can hold upto 38 bytes so how do I load
the llValue array into the field??