Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL V8 Records in Varray

PL/SQL V8 Records in Varray

From: <malbete_at_platinum.com>
Date: Mon, 03 Aug 1998 16:46:55 +0000
Message-ID: <35C5E97F.6CF5@platinum.com>


Hi,

Is there a way to initialize a Varray of Records with its constructor.

DECLARE

	TYPE Person IS RECORD (
		name		VARCHAR2(20),
		age		NUMBER(3)) ;
	TYPE Audience IS VARRAY (100) OF Person ;
	Opera Audience := Audience ( ???? );
BEGIN
        DBMS_OUTPUT.PUT_LINE (Opera(1).name) ;
        ...

END ; I'll be very grateful for any help ! Thanks. So far,
Vincent Received on Mon Aug 03 1998 - 11:46:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US