Hello. Could you help me please, wtih the following issue: As I initializate a nested table at the some time of declaration :
DECLARE TYPE table_contacts IS TABLE OF VARCHAR2(1024); tab table_contacts := table_contacts('John','George','Merkel'); BEGIN dbms_output.put_line(tab(1)); dbms_output.put_line(tab(2)); dbms_output.put_line(tab(3)); END; Isn't not possible to do something similar with the assciative arrays : DECLARE TYPE assoc_array IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30); state_array assoc_array; BEGIN state_array('Alaska') := 'Juneau'; state_array('California') := 'Sacramento'; state_array('Oregon') := 'Salem'; state_array('Washington') := 'Olympia'; dbms_output.put_line(state_array('Alaska')); dbms_output.put_line(state_array('California')); dbms_output.put_line(state_array('Oregon')); dbms_output.put_line(state_array('Alaska')); END; It's possible initilizate this array with this values in the declaration section ? Someting similar to the first example? Regards, Paulito Santana -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en