Using pl/sql tables with Object types

From: Seth <sgelberg_at_optonline.net>
Date: 27 May 2004 13:02:21 -0700
Message-ID: <f3159b28.0405271202.56440fdb_at_posting.google.com>

I have a string that houses tag/value pairs as 10=TXCC|11=ABC|88=POP

An associative Table (formerly PL/SQL Table) would be perfect to store the tag/values in once parsed since the string will parse out as a sparce array.

The problem is that I use oracle objects (yeah I know sorry we did, but have already gone too far down that path to convert to procedures/packages) and would like to have the associative table as one of its attributes. This will allow me to look up the tag rather than have an attribute for each tag.

Any ideas on how to do this, seems Object Attributes can only be sql data types and associative tables are only valid in pl/sql.

I cannot use varrays cause of the sparcity. Received on Thu May 27 2004 - 22:02:21 CEST