dbms_random&varray

Hi All

I’d like to fill up varray table by using dbms_random.(oracle 9.2) In this case (look example) I get error ORA-06533 as a result of wrong implicit extend method, I suppose.
But in another case when I’m write explicit Extend like this: V_TABLE.Extend(v_in) I have the same problem. So Can I have any suggestions?

Example:

DECLARE V_IN NUMBER(2);
TYPE table_v IS VARRAY(3) OF NUMBER; V_TABLE TABLE_v;

BEGIN v_in := dbms_random.VALUE(1,3);
v_table := TABLE_v(V_IN);

DBMS_OUTPUT.PUT_LINE(TO_CHAR(V_TABLE(1))||'|'||TO_CHAR(V_TABLE(2))||'|'||TO_CHAR(V_TABLE(3))); --or
for idx in v_table.first..v_table.last loop DBMS_OUTPUT.PUT_LINE(TO_CHAR(v_Table(idx))); end loop;

END; / Received on Sun Apr 15 2007 - 04:53:10 CDT