How to use the type of CREATE TYPE?

From: Patrick Lo <cylo_at_vtc.edu.hk>
Date: Thu, 22 Mar 2001 09:58:19 +0800
Message-ID: <3AB95C3A.591148F7@vtc.edu.hk>

Hi,

I am new to the CREATE TYPE, CREATE TYPE BODY. I would like to create a type of an array of string and it would be used in PL/SQL package. However, I found that I could not use it. My case is as followed :

CREATE TYPE arr_string AS TABLE OF VARCHAR2;

CREATE OR REPLACE PACKAGE tools AS

   FUNCTION splitString(

            PIV_string IN VARCHAR2,
            PIN_break  IN NUMBER,
            PIO_string OUT arr_string
           )

   RETURN BOOLEAN;
END;
/

When I compile this package specification, error will appear. It said that object arr_string is invalid.

What should I do ? Besides, can anyone tell me other examples about create type(except the ones on the SQL reference of Oracle menu)?

Thanks a lot.

--
Patrick Lo

Received on Wed Mar 21 2001 - 19:58:19 CST