'Is there Oracle RecordType equivalence in PostgreSQL
I am converting a Oracle Package to PostgreSQL stored procedure. The Oracle package has "Record" Type in it, is there any equivalence in PostgreSQL for "Record" Type in PostgreSQL?
Here is the code.
CREATE OR REPLACE PACKAGE BODY LODAXR_TICP_O_pkg02
IS
g_chnl_key NUMBER := 0;
g_crrnt_user VARCHAR2(50);
TYPE g_entity_dtl_rec IS RECORD
(
entity_id VARCHAR2(5 CHAR),
bank_id VARCHAR2(4 CHAR),
branch_id VARCHAR2(10 CHAR),
lob_cd VARCHAR2(15 CHAR),
acct_num VARCHAR2(15 CHAR),
)
g_rec_01 g_entity_dtl_rec;
....
....
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
