1)Strip all Postgres and or user-specific custom datatypes
for ex if you see an in or out var declared as fubar chances are this wont map
correctly in Oracle
2)Get to know packages..they work well to aggregate and organise
2a)Functions and Procedures which are used for a specific purpose for example
HL7 events such as A01,A03 or A08 would be different implementations
of a package base class A00 (Health Level 7) Base Structure
2b)Variables and or attributes which would support the Package type in my case
HL7_Event_Type would be A01,A03 or A08
The safest way to transport functions is to code required functionality in Java
such as
CREATE OR REPLACE FUNCTON java_pkg AS
FUNCTION phone_fmt
(p_phone IN VARCHAR2)
RETURN VARCHAR2
IS
LANGUAGE JAVA
NAME 'JavaPackageName.JavaClassName.getString (char[]) return char[]';
END;
/
/* contents of JavaPackageName.JavaClassName */
package JavaPackageName;
public class JavaClassName
{
public String aString=new String("fubar");
public JavaClassName() { ; } //default constructor
public JavaClassName(char[] aString) //constructor with 1 string arg
{
System.out.println("JavaClassname has one input which is a String
contents="+aString);
}
public getString(char[] input_string)
{
this.aString = new java.lang.String(input_string);
return this.aString;
}
}
HTH
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confidential nature and Sender does not
endorse distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
Date: Thu, 26 Feb 2009 22:36:56 -0800
From: abr_...@yahoo.com
Subject: [GENERAL] PostgreSQL to Oracle
To: pgsql-general@postgresql.org
Hi All,
I want to migrate from PostgreSQL to Oracle and need any tool preferably open
source. And I am specially concerned with stored procedures / functions.
Regards,
Abdul Rehman.
_________________________________________________________________
Windows Live™ Hotmail®…more than just e-mail.
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_howitworks_022009
