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
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 |