Newsgroups: comp.databases.oracle.server
From: ExecMan <artme...@yahoo.com>
Date: Wed, 14 Mar 2012 14:26:02 -0700 (PDT)
Local: Wed, Mar 14 2012 5:26 pm
Subject: Collection Help
Hi,
I have a multi-level collection, indexed by VARCHAR2. After I fill it
The actual error is referring to the first FOR index1 loop.
Thanks in advance!
TYPE order_rec IS RECORD (
TYPE order_tab IS TABLE OF order_rec INDEX BY VARCHAR2(30);
TYPE registration_rec IS RECORD (
TYPE registration_tab IS TABLE OF registration_rec INDEX BY
v_order_tab REGISTRATION_TAB;
BEGIN
FOR index1 IN v_order_tab.FIRST .. v_order_tab.LAST LOOP
v_order_tab(index1).order_data(index2).order_cnt || ',' ||
v_order_tab(index1).order_data(index2).order_amt;
UTL_FILE.PUT_LINE(v_file_id,v_string1 || ',' || v_string2);
ERROR at line 1:
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||