APEX

Hello,

I am attempting to modify Vikas' (now quite old) code to upload a CSV to a table through APEX. Everything worked fine with it to start with, but now I am getting the error stated in the subject. So far as I can tell, the collection is being successfully created by the following code:

if htmldb_collection.collection_exists(p_collection_name) = TRUE then

htmldb_collection.delete_collection(p_collection_name);

end if;

htmldb_collection.create_collection(p_collection_name);

But when it gets to the code later on that tries to actually use it, the error spits out and everything blows up. I've been scouring the forums all day, but I have never used collections before and can't find anything wrong with the code... Here's the snippet that tries to use the collection:

for i in 2..l_records.count
loop
csv_to_array(l_records(i), l_record);
l_seq_id := htmldb_collection.add_member(p_collection_name, 'dummy');
for i in 1..l_record.count
loop
htmldb_collection.update_member_attribute
(p_collection_name => p_collection_name
,p_seq => l_seq_id
,p_attr_number => i
,p_attr_value => l_record(i) );
end loop;
end loop;

Both snippets exist in the same function, and nothing that even references a collection occurs between them. 'G_COLLECTION' is the name of a global application item passed to the function from APEX.

Can anyone more experienced see anything wrong or give any tips of things to look for? I am using APEX version 3.0.1.00.08. Thanks for any help!

Eric