Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7A37B636656
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 Aug 2009 19:05:43 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 36994-02-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 Aug 2009 22:05:27 +0000 (UTC)
X-Greylist: delayed 00:11:41.326662 by SQLgrey-1.7.6
Received: from gatekeeper.stratagroup.com (gatekeeper.strata-group.com
	[199.217.206.66])
	by mail.postgresql.org (Postfix) with ESMTP id 8D1B2634E4D
	for <pgsql-sql@postgresql.org>; Wed, 19 Aug 2009 19:05:32 -0300 (ADT)
Received: from mercury.strata-group.com (mercury [131.124.0.23])
	by gatekeeper.stratagroup.com (8.13.1/8.13.1) with ESMTP id
	n7JLo1uZ008870
	for <pgsql-sql@postgresql.org>; Wed, 19 Aug 2009 16:50:01 -0500 (CDT)
Received: from strata-group.com ([131.124.0.8])
	by mercury.strata-group.com (8.14.3/8.14.3) with ESMTP id
	n7JLpSWo015051
	for <pgsql-sql@postgresql.org>; Wed, 19 Aug 2009 16:51:29 -0500 (CDT)
x-mimeole: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
Subject: Call Procedure From Trigger Function
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CA2117.877F89AD"
Date: Wed, 19 Aug 2009 16:53:41 -0500
Message-ID: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Call Procedure From Trigger Function
Thread-Index: AcohF4QC1G81XAtIQ+icNZGW6gOCeQ==
From: "Doug Pisarek" <dgp@strata-group.com>
To: <pgsql-sql@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/107
X-Sequence-Number: 33016

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA2117.877F89AD
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I am in the process of coverting an Oracle 10.2.0.3 database to
Postgresql 8.3. I have a number of triggers in Oracle that make a call
to packages.
I know I will need to re-write the Oracle packages to postgres
functions. The issue which I have can I make a procedure call from
inside a postgres trigger function?
=20
Thanks,
Doug P.

------_=_NextPart_001_01CA2117.877F89AD
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16890" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial size=3D2>I am =
in the process=20
of coverting an Oracle 10.2.0.3 database to Postgresql 8.3. I have a =
number of=20
triggers in Oracle that make a call to packages.</FONT></SPAN></DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial size=3D2>I know =
I will need=20
to re-write the Oracle packages to postgres functions. The issue which I =
have=20
can I make a procedure call from inside a postgres trigger=20
function?</FONT></SPAN></DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial=20
size=3D2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial size=3D2>Doug=20
P.</FONT></SPAN></DIV></BODY></HTML>

------_=_NextPart_001_01CA2117.877F89AD--