Skip to Main Content

SQL & PL/SQL

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!

initializing associative array in package specification

ManjitAug 2 2007 — edited Aug 2 2007
Can some one tell me a way to initialzie an associate array in package specification.

See below to what I am doing at present,but I believe is not clean because the value never changes and is used all over by package.

Help.

------------

function notify_feed_file(p_event_file_seq IN event_file.EVENT_FILE_SEQ%type) return error_message.error_code%type
is
Type list_of_events_t is table of event.event_code%type index by binary_integer;
list_of_events list_of_events_t;
BEGIN
list_of_events(1) := 'A01';
list_of_events(2) := 'A03';
list_of_events(3) := 'A05';

.
--------
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2007
Added on Aug 2 2007
9 comments
2,927 views