How do I extract an array of 64-bit words???

From: DCCoolBreeze <aa_at_bb.net>
Date: Fri, 17 Aug 2001 16:17:57 -0400
Message-ID: <9lju12$fbu$1@bob.news.rcn.net>

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 Received on Fri Aug 17 2001 - 15:17:57 CDT