how to use userdefined datatype in Oracle 8i

[Sona Patel]

Hello All...

I have created user defined datatype in oracle 8i as seen below.

   
create or replace type Temp_TStrings as table of varchar2(4000); 
/

I want to use this variable in oracle 8i as seen below.

  
CREATE OR REPLACE function my_join
(
    p_cursor sys_refcursor,
    p_del varchar2 := ','
) return varchar2
is
strList         Temp_TSTRINGS;

begin

strList := new Temp_TSTRINGS(); --- This is ORACLE 9i syntax. ( It is creating problem in 8i. How to do so in 8i?)
-
-
-
end
/

how to use this user defined datatype in function in oracle 8i?

Thanks

[Agador Paloi]

it ran ok on 11i after putting a ';' after your end statement. Not sure why it would not run if 8i supports object types.