Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to check if a field in a 2-dimon Array is initialized?

580998Jun 11 2007 — edited Jun 11 2007
hello everyone, I habe a problem,

a 2-dim array,

TYPE A IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
TYPE B IS TABLE OF A INDEX BY PLS_INTEGER;

x A;

I want to increment the data in x, but don't want to initialize every element in x, so how can I check if every field in the array is initialized?

I have tried with null as: if the_element is null then

the compile result is: data not found.

so how can i do it now?

thx a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2007
Added on Jun 11 2007
1 comment
140 views