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.
