You could use a pl/sql procedure that returns a cursor_ref which decodes everything correctly.
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 12:23 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Retrieving multi-level tables from an Oracle DB On Mon, Sep 13, 2004 at 09:58:56AM -0400, [EMAIL PROTECTED] wrote: > > CREATE TYPE rule_expression_t AS OBJECT ( > CREATE TYPE rule_t AS TABLE OF rule_expression_t; > CREATE TABLE filter_rules ( > )NESTED TABLE rule STORE AS filter_rules_nested_table; > > What I would like to do, if possible, is make one query (along the lines > of "SELECT rule FROM filter_rules") and stuff the results into a > three-dimensional list (something like > @rules_list[rule][rule_expression][field of rule_expression]). > Is there a way to do this using DBI and DBD::Oracle? Not in the way you'd like. DBD::Oracle currently doesn't support named types. I'd like to add good support for them but it's non-trivial. You could do it and send me a patch, wait till I do it myself (which won't be anytime soon given my other plans for DBI etc), or pay someone, like me, to take time out to do it for you. Meanwhile, you'll need to 'flatten' the select so it returns 'plain' data types. Tim. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
