My Stored Procedures based on the Oracle DB. If i do DB migration from Oracle to PostgreSQL, can i do any change in the already existing Stored Procedures?
Stored Procedures are stored in the DB schema they were created in. And normally they will be written in DB-specific procedural language - PL/SQL in the case of Oracle. Postgres does not support PL/SQL, it does however support PL/Perl, PL/Python, PL/pgSQL and PL/TCL. None are exactly like PL/SQL, but will look pretty simmilar. You will have to change all your SPs to be written in one of these and recreate the SPs in your Postgres schema.
I am not familiar with a Procedure or StoredProcedure class in the JDK. Which class are you talking about?
Oracle 8i and up does have the concept of a Java Stored Procedure. But this is a proprietory class which runs in the Oracle DB, and can't be run in another database. [ March 04, 2005: Message edited by: Paul Sturrock ]