Re: dbms_random&varray

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 15 Apr 2007 05:50:05 -0700
Message-ID: <1176641405.929241.144810@d57g2000hsg.googlegroups.com>

On Apr 15, 2:37 pm, Ora_PL <p..._at_onet.eu> wrote:
> Michel Cadot:
>
>
>
> > PL/SQL procedure successfully completed.
>
> > SQL> @v
>
> > Version Oracle : 9.2.0.8.0
>
> > Regards
> > Michel Cadot
>
> Yes, but if you set serverout on, you should get less friendly answer.

Without serveroutput being on you wouldn't see the dbms_output output, so it was on in Michel's test. The problem with your testcase is most probably that you attempt to output three values from the varray, while there is always only one.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Sun Apr 15 2007 - 07:50:05 CDT