search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
1.02k stars 343 forks source link

number_array not being converted in PLSQL #1592

Open smileatom opened 1 year ago

smileatom commented 1 year ago

Vars of type number_array are not being detected by the scanner or converted. number_array does not exist in PLPGSQL

number_array should be converted to an appropriate array type for example integer[]

Also array initializers are not being converted from := (n, n, n) to := [n, n, n]