On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote:
> Here is the snippet of it.
> TYPE INV_LINES_RT IS RECORD(
> VENDOR_NUM A.Datastore.VENDOR_NUM%TYPE,
> VENDOR_SITE_CODE A.Datastore.VENDOR_SITE_CODE%TYPE,
> INVOICE_NUM A.Datastore.INVOICE_NUM%TYPE,
> TXN_CNT NUMBER
> );
You can create a composite type in PostgreSQL:
CREATE TYPE complex AS (r integer, i integer);
> TYPE INV_LINES_T IS TABLE OF INV_LINES_RT;
You would use an array in this case:
DECLARE
carr complex[];
Yours,
Laurenz Albe