DEV Community

Gamma
Gamma

Posted on

Member function & member procedure from the oracle to postgresql

create or replace TYPE "TEST_ACC" AS OBJECT(
create or replace TYPE "TEST_ACC" AS OBJECT(
OGID VARCHAR2(6),
ACCT VARCHAR2(10),
member procedure TEST_ACC_I (ADT IN VARCHAR2),
member function TEST_ACC_II RETURN VARCHAR2
);

create or replace TYPE BODY "TEST_ACC" AS
MEMBER PROCEDURE TEST_ACC_I(ADT IN VARCHAR2) IS
BEGIN
OGID :=RPAD(trim(replace(replace(SUBSTR(ADT, 1,6),CHR(9),''),chr(13),'')), 6, ' ');
ACCT := RPAD(trim(replace(replace(SUBSTR(ADT, 7,10),CHR(9),''),chr(13),'')), 10, ' ');
END;
MEMBER FUNCTION TEST_ACC_II
RETURN VARCHAR2 IS
BEGIN
RETURN RPAD(trim(replace(replace(OGID, chr(9), ''),chr(13),'')), 6, ' ') ||
RPAD(trim(replace(replace(ACCT, chr(9), ''),chr(13),'')), 10, ' ') ||

END;
END;

ORA CODE: Using the below code from the other procedure.

v_t_acc := TEST_ACC(null, null, null, null);

How to convert this into postgresql

ORA CODE: Using in the other procedure.

v_t_acc := TEST_ACC(null, null, null, null);

Top comments (0)