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 gkittelson 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 get 3 64-bit array from a single NUMBERIC field

Status
Not open for further replies.

DCCoolBreeze

Programmer
Jul 25, 2001
208
US
I have inserted an array of 3 64-bit words as follows:

insert into table(numeric1,numeric2) values( 64bword[0] || 64bword[1] || 64bword[2], intValue);

NOTE: the array is stored in a single numeric field

It works great! However, how can I get these values back into the array???

define cursor
fetch ... into ????
TRIED: :64bword[0] || :64bword[1] || :64bword[2], :intValue

struct test {
word64 llValue[3];
int intValue;
}

struct ... structPtr;

:structPtr
:)64bword[0] || :64bword[1] || :64bword[2]), :intValue
etc. etc.

I have tried all sorts of combinations but cannot get the values. Any suggestions? I am working in ProC
and using Oracle 8.1.7 on Solaris
Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top