469,167 Members | 1,377 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Using pl/sql tables with Object types

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.
Jul 19 '05 #1
0 1914

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Daveyk0 | last post: by
19 posts views Thread by Kamilche | last post: by
1 post views Thread by Taylor | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.