Thread: EDB - oracle compatibility (Nested Tables)

EDB - oracle compatibility (Nested Tables)

From
cognizant
Date:
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.

Re: EDB - oracle compatibility (Nested Tables)

From
"Joshua D. Drake"
Date:
On 04/05/2012 08:16 AM, cognizant wrote:
>
> 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.

Advanced Server is not a community product. You may want to check with
EDB support.

Sincerely,

Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579

Re: EDB - oracle compatibility (Nested Tables)

From
cognizant
Date:
What abt the compatibility w.r.to PostgreSQL?


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/EDB-oracle-compatibility-Nested-Tables-tp5620654p5622857.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: EDB - oracle compatibility (Nested Tables)

From
John R Pierce
Date:
On 04/06/12 7:21 AM, cognizant wrote:
> What abt the compatibility w.r.to PostgreSQL?
>

community postgresql has no pretentions of being Oracle compatible.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast