PL/SQL (MOSC)

MOSC Banner

to access record type in a record pl/sql

edited Oct 6, 2015 2:56PM in PL/SQL (MOSC) 1 commentAnswered ✓

Hi

Im trying to query a record type in a procedure. here below is the code and error

Code:

CREATE OR REPLACE PACKAGE APPS.xx_suppliers

IS

TYPE supp_attr IS RECORD (p_attribute1        ap_invoices_all.attribute1%TYPE

                             ,p_attribute2     ap_invoices_all.attribute2%TYPE

                             ,p_attribute3     ap_invoices_all.attribute3%TYPE

                             ,p_attribute4     ap_invoices_all.attribute4%TYPE);

TYPE xx_supp_contacts IS RECORD

   (

     p_contact_id                 number

   , p_contact_role_id                 number

   , p_attributes           supp_attr );

TYPE contacts_tb    IS TABLE OF xx_supp_contacts ;

TYPE supp_details IS RECORD

   (

     p_vendor_id                 ap_suppliers.vendor_id%TYPE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center