Re: [GENERAL] Using oracle stored procedures for postgresql database

2013-09-22 Thread John R Pierce
On 9/22/2013 9:01 PM, nikhilruikar wrote: Thanks for response, but what I am exactly looking at is using stored procedures written for oracle as it is for postgres database. Is it possible? If not is there any referance document available for converting orac

Re: [GENERAL] Using oracle stored procedures for postgresql database

2013-09-22 Thread nikhilruikar
hi all Thanks for response, but what I am exactly looking at is using stored procedures written for oracle as it is for postgres database. Is it possible? If not is there any referance document available for converting oracle stored procedures to postgresql Tha

Re: [GENERAL] Using oracle stored procedures for postgresql database

2013-09-20 Thread Pavel Stehule
013 11:50 > À : pgsql-general@postgresql.org > Objet : [GENERAL] Using oracle stored procedures for postgresql database > > Hi > I am planning to migrate oracle database to postgres. I need to know > if there are any plugins or tool with which I can use stored procedures > wri

Re: [GENERAL] Using oracle stored procedures for postgresql database

2013-09-20 Thread Jayadevan M
Hi, Have a look at orafce for the plugins. Try ora2pg for initial migration. There are differences in how you execute procedures (syntax), packages are missing in PostgreSQL and so on. Please have a look at http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Oracle Regar

Re: [GENERAL] Using oracle stored procedures for postgresql database

2013-09-20 Thread BOUVARD Aurélien
lto:pgsql-general-ow...@postgresql.org] De la part de nikhilruikar Envoyé : vendredi 20 septembre 2013 11:50 À : pgsql-general@postgresql.org Objet : [GENERAL] Using oracle stored procedures for postgresql database Hi I am planning to migrate oracle database to postgres. I need to know if ther

[GENERAL] Using oracle stored procedures for postgresql database

2013-09-20 Thread nikhilruikar
Hi I am planning to migrate oracle database to postgres. I need to know if there are any plugins or tool with which I can use stored procedures written in oracle schema for postgres with out changing them. Thanks in advance -- View this message in context: http://postgresql.1045698.n5.n