Re: How to use the type of CREATE TYPE?

"Patrick Lo" <cylo_at_vtc.edu.hk> wrote in message news:3AB95C3A.591148F7_at_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
>
>

show errors and provide a more *exact* error message.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Mar 22 2001 - 00:41:16 CST