pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedMigrated Oracle database to PostgreSQL ??
3+ messages / 2 participants
[nested] [flat]
* Migrated Oracle database to PostgreSQL ??
@ 2005-04-04 13:41 Dinesh Pandey <dpandey@secf.com>
0 siblings, 1 reply; 3+ messages in thread
From: Dinesh Pandey @ 2005-04-04 13:41 UTC (permalink / raw)
To: pgsql-sql; pgsql-bugs-owner@postgresql.org
Hi there,
Has anyone migrated Oracle database to PostgreSQL? If yes, could you please
help me -
1. How to migrate Procedures and Packages from Oracle to PostgreSQL????
2. How to find error messages in PostgreSQL thrown from an Exception (as we
can get messages in Oracle with "SQLERRM" keyword)
for example --
--Raise an exception
RAISE EXCEPTION 'No Data found for record id % ' ,recordid
--Insert exception messages into database
EXCEPTION
IF RAISE_EXCEPTION THEN
-- my_insert_function(SQLERRM);
Thanks in advance.
Regards
Dinesh Pandey
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Migrated Oracle database to PostgreSQL ??
@ 2005-04-04 19:35 Yasir Malik <ymalik@cs.stevens.edu>
parent: Dinesh Pandey <dpandey@secf.com>
0 siblings, 1 reply; 3+ messages in thread
From: Yasir Malik @ 2005-04-04 19:35 UTC (permalink / raw)
To: pgsql-sql
> 1. How to migrate Procedures and Packages from Oracle to PostgreSQL????
>
>
> 2. How to find error messages in PostgreSQL thrown from an Exception (as we
> can get messages in Oracle with "SQLERRM" keyword)
> for example --
>
> --Raise an exception
> RAISE EXCEPTION 'No Data found for record id % ' ,recordid
>
> --Insert exception messages into database
> EXCEPTION
> IF RAISE_EXCEPTION THEN
> -- my_insert_function(SQLERRM);
All your answers can be found here:
http://www.postgresql.org/docs/8.0/static/plpgsql.html
I can't say if PL/pgSQL is as good as PL/SQL, though.
Yasir
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Migrated Oracle database to PostgreSQL ??
@ 2005-04-04 19:57 Dinesh Pandey <dpandey@secf.com>
parent: Yasir Malik <ymalik@cs.stevens.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Dinesh Pandey @ 2005-04-04 19:57 UTC (permalink / raw)
To: 'Yasir Malik' <ymalik@cs.stevens.edu>; pgsql-sql
Yes, but after creating some function, we can get sql error messages. But I
not comfortable that much in that.
For Procedures and Packages we can use Functions....
Any other option in pl/PGSQL????
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Yasir Malik
Sent: Tuesday, April 05, 2005 1:06 AM
To: PostgreSQL
Subject: Re: [SQL] Migrated Oracle database to PostgreSQL ??
> 1. How to migrate Procedures and Packages from Oracle to PostgreSQL????
>
>
> 2. How to find error messages in PostgreSQL thrown from an Exception
> (as we can get messages in Oracle with "SQLERRM" keyword)
> for example --
>
> --Raise an exception
> RAISE EXCEPTION 'No Data found for record id % ' ,recordid
>
> --Insert exception messages into database
> EXCEPTION
> IF RAISE_EXCEPTION THEN
> -- my_insert_function(SQLERRM);
All your answers can be found here:
http://www.postgresql.org/docs/8.0/static/plpgsql.html
I can't say if PL/pgSQL is as good as PL/SQL, though.
Yasir
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-04 19:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-04 13:41 Migrated Oracle database to PostgreSQL ?? Dinesh Pandey <dpandey@secf.com>
2005-04-04 19:35 ` Yasir Malik <ymalik@cs.stevens.edu>
2005-04-04 19:57 ` Dinesh Pandey <dpandey@secf.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox