Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I insert 3 64-bit array into NUMBERIC field

Status
Not open for further replies.

DCCoolBreeze

Programmer
Jul 25, 2001
208
US
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??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top