From dpandey@secf.com Mon Apr  11 13:41:57 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 12AD453525
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Apr 2005 10:41:57 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 24586-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 11 Apr 2005 13:41:52 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id F0F0153374
	for <pgsql-sql@postgresql.org>; Mon, 11 Apr 2005 10:41:50 -0300 (ADT)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000608234.msg
	for <pgsql-sql@postgresql.org>; Mon, 11 Apr 2005 06:41:43 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: How to Port Oracle's user defined "Package" into Postgres 8.0.1.
Date: Mon, 11 Apr 2005 19:09:05 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0018_01C53EC9.F05C8130"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
Thread-Index: AcU+m9RlN2cZf9H0T+2dPCi/ZN4iDw==
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Mon, 11 Apr 2005 06:41:43 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Mon, 11 Apr 2005 06:41:48 -0700
Message-Id: <20050411134150.F0F0153374@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.41 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID
X-Spam-Level: *
X-Archive-Number: 200504/152
X-Sequence-Number: 21045

This is a multi-part message in MIME format.


------=_NextPart_000_0018_01C53EC9.F05C8130
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi folks,

Can any one give me an idea about:

How to Port Oracle's user defined "Package" into Postgres 8.0.1.

If possible pls attache sample code.

Thanks
Dinesh Pandey 

------=_NextPart_000_0018_01C53EC9.F05C8130
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7036.0">
<TITLE>How to Port Oracle's user defined &quot;Package&quot; into =
Postgres 8.0.1.</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Verdana">Hi folks,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">Can any one give me an idea =
about:</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">How to Port Oracle's user defined =
&quot;Package&quot; into Postgres 8.0.1.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">If possible pls attache sample =
code.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">Thanks<BR>
Dinesh Pandey</FONT><FONT FACE=3D"Times New Roman"></FONT>=20
</P>

</BODY>
</HTML>
------=_NextPart_000_0018_01C53EC9.F05C8130--




From col@mportal.hu Fri Apr  15 22:17:41 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D277C537A4
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 15 Apr 2005 19:17:41 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 40455-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 15 Apr 2005 22:17:32 +0000 (GMT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id DD67752961
	for <pgsql-sql@postgresql.org>; Fri, 15 Apr 2005 19:17:32 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.13.1/8.13.1) with ESMTP id j3FMHWTE041995
	for <pgsql-sql@postgresql.org>; Fri, 15 Apr 2005 22:17:32 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.13.1/8.13.1/Submit) id j3FLs9gG035760
	for pgsql-sql@postgresql.org; Fri, 15 Apr 2005 21:54:09 GMT
	(envelope-from news)
From: CoL <col@mportal.hu>
X-Newsgroups: pgsql.sql
Subject: Re: How to Port Oracle's user defined "Package" into Postgres 8.0.1.
Date: Fri, 15 Apr 2005 23:58:58 +0200
Organization: Hub.Org Networking Services
Lines: 15
Message-ID: <d3pd61$12ta$1@news.hub.org>
References: <20050411134150.F0F0153374@svr1.postgresql.org>
Reply-To: col@mportal.hu
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.8b2) Gecko/20050303
In-Reply-To: <20050411134150.F0F0153374@svr1.postgresql.org>
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Archive-Number: 200504/264
X-Sequence-Number: 21157

hi,
Dinesh Pandey wrote, On 4/11/2005 15:39:
> 
> 
> Hi folks,
> 
> Can any one give me an idea about:
> 
> How to Port Oracle's user defined "Package" into Postgres 8.0.1.

there is no Package in postgresql. You have to rewrite the logic, 
extract the functions from Package and recreate them for postgres. But 
you can't port 1:1 oracle packages to pg.

C.