|
-
Hi Vince,
I had problems finding docco on this as well. Here's what you're looking for:
DECLARE
TYPE day_sched IS RECORD(open1 PLS_INTEGER, close1 PLS_INTEGER,
open2 PLS_INTEGER, close2 PLS_INTEGER);
TYPE week_sched IS VARRAY(7) OF day_sched;
i_week_sched week_sched;
BEGIN
-- Initialise
i_week_sched := week_sched();
-- Add an element
i_week_sched.EXTEND;
-- Insert an element
i_week_sched(i_week_sched.LAST).open1 := 1;
-- Add an element
i_week_sched.EXTEND;
-- Insert an element
i_week_sched(i_week_sched.LAST).open1 := 2;
-- Print the elements
FOR i IN i_week_sched.FIRST..i_week_sched.LAST
LOOP
DBMS_OUTPUT.PUT_LINE(i_week_sched(i).open1);
END LOOP;
END;
Cheers,
CM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|