f you want to define a specific RECORD type, you need to use the TYPE ... IS RECORD statement in the declaration part of any procedure or function. The following example script defines a RECORD type called STUDENT:

CREATE OR REPLACE PROCEDURE HELLO AS

TYPE student IS RECORD (

id NUMBER(5),

first_name VARCHAR(80),

last_name VARCHAR(80)

);

BEGIN

NULL;

END;

/