Table of Contents

Search

  1. Preface
  2. Introduction to the Stored Procedure Accelerator for Oracle
  3. Masking Stored Procedures and User-Defined Table Functions
  4. Stored Procedure Accelerator Setup
  5. Stored Procedure Accelerator Rules

Stored Procedure Accelerator Guide for Oracle

Stored Procedure Accelerator Guide for Oracle

Multi-Level Object/Table Types

Multi-Level Object/Table Types

Object types must have primitive types attributes.
You cannot use custom or user-defined Object types as attributes inside another Object definition. You cannot have a hierarchy of Object types.
For example, the following text is a command that returns unmasked data because it defines an attribute type inside an attribute and defines a function inside an attribute:
create or replace TYPE employee_typ AS OBJECT( employee_id NUMBER(6) first_name VARCHAR2(20) last_name VARCHAR2(25) address address_typ // Type inside type MEMBER FUNCTION get_idno RETURN SYS_REFCURSOR, // Function inside type );

0 COMMENTS

We’d like to hear from you!