DCCoolBreeze
Programmer
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
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