From oracle-l-bounce@freelists.org Wed Feb 25 08:13:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1PEDen05637 for ; Wed, 25 Feb 2004 08:13:41 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1PEDeo05632 for ; Wed, 25 Feb 2004 08:13:40 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C336394FED; Wed, 25 Feb 2004 09:15:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 25 Feb 2004 09:14:04 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from aphrodite.espn.com (aphrodite.espn.com [204.149.192.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 42C91394FB8 for ; Wed, 25 Feb 2004 09:14:01 -0500 (EST) Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FBAA.0064B4F7" X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Subject: RE: Issue involving Trigger , PL/SQL Procedure & a Java stored procedure Date: Wed, 25 Feb 2004 09:16:46 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Issue involving Trigger , PL/SQL Procedure & a Java stored procedure Thread-Index: AcP7qKw0zp/bgWRsSHSWvCoCqCPmTwAAOHgQ From: "Jamadagni, Rajendra" To: X-OriginalArrivalTime: 25 Feb 2004 14:16:44.0166 (UTC) FILETIME=[FEEF8260:01C3FBA9] X-archive-position: 1869 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rajendra.Jamadagni@espn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C3FBAA.0064B4F7 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Shouldn't this happen AFTER the data got = committed??=20 consider the scenario ... you add a row, and _assume_ your code works = right and=20 it spits out a text file. After the text file is complete, your = transaction=20 rolls back for any reason ... aren't you dealing with = inconsistent=20 data??

Raj

----------------------------------------------------------------= ----------------=20
Rajendra dot Jamadagni at = nospamespn dot=20 com
All Views expressed = in this email=20 are strictly personal.
select=20 standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an = opinion is an=20 art !

-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of ramalingam.rangadoure@tcs.com
Sent: Wednesday, = February 25, 2004 8:56 AM
To:=20 oracle-l@freelists.org
Subject: Issue involving Trigger , = PL/SQL=20 Procedure & a Java stored procedure

Hi all,
Scenario:
We have an=20 issue with PL/SQL Trigger involving another PL/SQL Procedure & a = Java=20 stored procedure.
The = trigger will be=20 invoked when ever there is any transaction occurs on a particular = table. This=20 calls a PL/SQL Procedure that inturn invokes a Java stored procedure.=20
The Java stored procedure = will reads=20 the data from the table and write it to a text file.
Issue:
The issue we are facing is that the Java stored procedure is = unable to=20 get the latest changes made to the table, which invoked the = trigger.=20
Example:
We have 4 records in the table. If we = insert another=20 record, then it inturns fires the trigger and that calls the procedure = and=20 Java stored procedure.
The = Java stored=20 procedure was able to select only the 4 records but not the 5 record = which has=20 fired the trigger.

The = event of=20 the trigger is mentioned as "after insert/delete/update for each row". =
Attached the code for your = reference.

Please let = me know if=20 anybody has a solution for this issue.

Thanks and Regards,
R.=20 Rangadoure

------_=_NextPart_001_01C3FBAA.0064B4F7-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------