Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger execute a stored procedure

Re: Trigger execute a stored procedure

From: <csb_manian_at_my-dejanews.com>
Date: Tue, 04 May 1999 15:26:31 GMT
Message-ID: <7gn3j2$c0s$1@nnrp1.dejanews.com>


Hi,
I hope you are using the commit statement inside the procedure itself. OR you are issuing the COMMIT in different session. Possibly if you made any changes to procedure recompile and try again.

Manian
csb_manian_at_hotmail.com

In article <3DeX2.5815$Ie6.2278166_at_WReNphoon4>,   luc_san_at_hotmail.com (LUC San) wrote:
> I use Oracle 7.3.3
> I have a trigger which one execute a stored procedure
> This stored procedure inserts or updates rows.
> Afert COMMIT, I don't find rows interted or updated by the procedure;
>
> Does anyone know this problem.
>
> Help please
>
> Thank
>
> luc_san_at_hotmail.com
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm)



>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 10:26:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US