USING RECORDS IN PS/SQL.

From: Javier Riera <javier_at_bitel.es>
Date: 1997/10/22
Message-ID: <344DE29C.20C8@bitel.es>#1/1

I am trying to declare a record datatype:         

	TYPE t_miRecord IS RECORD
    	(
        	val1	binary_integer default 3,
        	val2	varchar2(30)  default 'hello',
      		val3	varchar2(30)  default 'bye',
        	val4	boolean default false
    	);

	into the package P1.

	I want to use this record in the package P2. So I declare

the next variable:

	miRecordVar	 P1.t_miRecord
		(
        		1,              	-- val1
        		'Good Morning',        -- val2
        		'Good Night',        	-- val3
        		true,          	-- val4
     		);

	But all I get is the next error message (compiling):



	(1):PLS-00801: error interno [21045]

	(2):PL/SQL: declaration ignored


	* Why this does not works?
	* Is there any way to inicialise the values of the fields of a record
		when I declare the record variable?

Thanks. Received on Wed Oct 22 1997 - 00:00:00 CDT