Re: dbms_random&varray

From: Ora_PL <ploug_at_onet.eu>
Date: Sun, 15 Apr 2007 14:20:40 +0200
Message-ID: <evt5aa$ai7$1@news.onet.pl>

Michel Cadot napisał(a):

> | Yes, but if you set serverout on, you should get less friendly answer.
>
> I don't understand your answer.
>
> Regards
> Michel Cadot
>
>

If you set 'serveroutput on' and use this method:

DBMS_OUTPUT.PUT_LINE(TO_CHAR(V_TABLE(1))||'|'||TO_CHAR(V_TABLE(2))||'|'||TO_CHAR(V_TABLE(3))); you get error ORA-06533.

try:

set serveroutput on

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 - 07:20:40 CDT