How To Define a Variable of a Specific RECORD Type

Q

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

✍: FYIcenter.com

A

Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defined with a regular data type and a specific RECORD type:

CREATE OR REPLACE PROCEDURE HELLO AS
  TYPE student IS RECORD (
    id NUMBER(5),
    first_name VARCHAR(80),
    last_name VARCHAR(80)
  );
  best_student student;
  another_student student;
  class_name VARCHAR2(80);
BEGIN
  NULL;
END;
/

2007-04-27, 4243👍, 0💬