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_at_vtc.edu.hk>
RETURN BOOLEAN;
END;
/
Date: Thu, 22 Mar 2001 09:58:19 +0800
Message-ID: <3AB95C3A.591148F7_at_vtc.edu.hk>
Hi,
[Quoted] 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 LoReceived on Thu Mar 22 2001 - 02:58:19 CET
