We are planning to move from Oracle to EDB(Postgresql 8.4). Also given the oracle compatibility as layed out in the document(http://www.enterprisedb.com/docs/en/9.1/oracompat/Postgres_Plus_Advanced_Server_Oracle_Compatibility_Guide-134.htm#P15974_787444), Ideally there should not be any changes made on the Java side. We started getting errors as soon as we hit the function using nested table. Please suggest what changes should be made for the migration and also whats the best approach to use nested table on EDB. SQL code create or replace TYPE OT_Ref_Country AS OBJECT ( countryId Integer, isoFullName Varchar2(256), doNotUseIndicator Integer ); create or replace TYPE NT_Ref_Countries IS TABLE OF OT_Ref_Country; FUNCTION getCountryList ( ip_countryId IN Ref_Country.countryid%TYPE,iop_NT_Ref_Countries in out NT_Ref_Countries ) RETURN Number ; Tks Mike -- View this message in context: http://postgresql.1045698.n5.nabble.com/EDB-oracle-compatibility-Nested-Tables-tp5620654p5620654.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
