How To Define a Specific RECORD Type

Q

How To Define a Specific RECORD Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL

✍: FYIcenter.com

A

If 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;
/

2007-04-27, 4321👍, 0💬