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