Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL to Oracle

From: Martin Gainty <mgainty(at)hotmail(dot)com>
To: <abr_ora(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org"<pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL to Oracle
Date: 2009-02-27 15:47:22
Message-ID: BLU142-W2935EAF30F0FB650EAD743AEAA0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-general
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_ora(at)yahoo(dot)com
Subject: [GENERAL] PostgreSQL to Oracle
To: pgsql-general(at)postgresql(dot)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

In response to

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2009-02-27 16:01:34
Subject: Re: Standalone ODBC Driver
Previous:From: LinosDate: 2009-02-27 13:54:36
Subject: Re: strange performance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group