Oracle conversion questions - TYPE's and ARRAY's

From: CS DBA <cs_dba(at)consistentstate(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Oracle conversion questions - TYPE's and ARRAY's
Date: 2016-02-25 19:45:56
Message-ID: 56CF59F4.5000302@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All;

We are running an Oracle conversion via ora2pg

the TYPE's come out like this:

CREATE OR REPLACE TYPE "CUST_ARRAY_TBL" as table of varchar2(4000);
or
CREATE OR REPLACE TYPE "STRTAB" as table of varchar2(4000 char);

The sqlplus code wants to use these types as array's like this:

BEGIN

...

myArrList := load_my_type();
myArrList.EXTEND(1);
myArrListSpecific := load_my_cust_arr_type();
myArrListSpecific.EXTEND(1);

IF inv_unpaid = 1 THEN
myArrListSpecific(myArrListSpecific.Last).FieldName := 'CUST_INV_ID';
myArrListSpecific(myArrListSpecific.Last).FieldValue := arr_desc_str;
myArrListSpecific.EXTEND(1);

...

Does anyone have any thoughts per converting the above to postgres and
PL/pgSQL?

Thanks in advance

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Ellerbrock 2016-02-25 23:42:30 Privileges granted on dblink extension function do not survive database dump and restore
Previous Message dangal 2016-02-25 18:55:03 Re: How Restricting user