you cannot get there from here.  There is nothing to assign TO until you create something there.

You are not going to get there from here.

But -- constructors can be very useful if you see the need to do this lots.

You might be interested only in the first one and not need the others:


ops$tkyte@ORA9IR2> CREATE OR REPLACE TYPE jean_TYPE_REC_test
  2  as object
  3   (
  4     l_a                    varchar2(10) ,
  5     l_b                    number  ,
  6     constructor function jean_TYPE_REC_test return self as result,
  7     constructor function jean_TYPE_REC_test(a in varchar2) return self as result,
  8     constructor function jean_TYPE_REC_test(b in number) return self as result
  9   )
 10  /
 
Type created.
 
ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2> CREATE OR REPLACE TYPE body jean_TYPE_REC_test
  2  as
  3  constructor function jean_TYPE_REC_test return self as result
  4  is
  5  begin
  6          return;
  7  end;
  8
  9  constructor function jean_TYPE_REC_test(a in varchar2) return self as result
 10  is
 11  begin
 12      self.l_a := a;
 13          return;
 14  end;
 15
 16  constructor function jean_TYPE_REC_test(b in number) return self as result
 17  is
 18  begin
 19      self.l_b := b;
 20          return;
 21  end;
 22
 23  end;
 24  /
 
Type body created.
 
ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2> declare
  2          l_rec jean_type_rec_test := jean_type_rec_test();
  3  begin
  4          l_rec.l_a := 'aa';
  5  end;
  6  /
 
PL/SQL procedure successfully completed.
 
 

you don't, not with records.  you would assign to it in the begin block.

using object types:


ops$tkyte@ORA9IR2> create or replace type scalarType as object ( empno number, ename varchar2(20) )
  2  /
 
Type created.
 
ops$tkyte@ORA9IR2> create or replace type tableType as table of scalarType
  2  /
 
Type created.
 
ops$tkyte@ORA9IR2>
ops$tkyte@ORA9IR2> declare
  2          l_data tabletype := tabletype( scalarType( 1, 'tom' ),
  3                                         scalarType( 2, 'lori' ) );
  4  begin
  5          null;
  6  end;
  7  /
 
PL/SQL procedure successfully completed.

you can 

ops$tkyte%ORA10GR2> create or replace type myScalarType as object
  2  ( x int, y date )
  3  /

Type created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create or replace type myTableType as table of myScalarType
  2  /

Type created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> declare
  2          l_unsorted myTableType := myTableType( myScalarType( 5, sysdate ), myScalarType( 1, sysdate-2 ) );
  3          l_sorted myTableType;
  4  begin
  5          select myScalarType(x,y) bulk collect into l_sorted
  6            from table( l_unsorted )
  7           order by x;
  8
  9          for i in 1 .. l_sorted.count
 10          loop
 11                  dbms_output.put_line( l_sorted(i).x || ', ' || l_sorted(i).y );
 12          end loop;
 13  end;
 14  /
1, 16-JUL-08
5, 18-JUL-08

PL/SQL procedure successfully completed.

ops$tkyte%ORA10GR2> variable txt varchar2(30)
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> exec :txt := 'a,b,c,hello,world,d,e,f'

PL/SQL procedure successfully completed.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> with data
  2  as
  3  (
  4  select
  5    trim( substr (txt,
  6          instr (txt, ',', 1, level  ) + 1,
  7          instr (txt, ',', 1, level+1)
  8             - instr (txt, ',', 1, level) -1 ) )
  9      as token
 10     from (select ','||:txt||',' txt
 11             from dual)
 12   connect by level <= length(:txt)-length(replace(:txt,',',''))+1
 13   )
 14   select * from data;

TOKEN
----------------------------------
a
b
c
hello
world
d
e
f

8 rows selected.

ops$tkyte%ORA11GR2> set serveroutput on;
ops$tkyte%ORA11GR2> CREATE TYPE O_TYPE is object (id number(38,0))
  2  /

Type created.

ops$tkyte%ORA11GR2> declare
  2   type to_type is table of o_type;
  3   my_object o_type;
  4   my_object2 o_type := o_type(null);
  5   my_table to_type := to_type() ;
  6  begin
  7   my_object.id := 123;
  8   my_object2.id := 123;
  9   my_table.extend;
 10   my_table(1) := my_object;
 11   dbms_output.put_line('id='||my_table(1).id);
 12   my_table(1) := my_object2;
 13   dbms_output.put_line('id2='||my_table(1).id);
 14  end;
 15  /
declare
*
ERROR at line 1:
ORA-06530: Reference to uninitialized composite
ORA-06512: at line 7