Re: Trigger execute a stored procedure

From: R. Steven Brown <rstevenbrown_at_earthlink.net>
Date: Mon, 3 May 1999 22:28:02 -0600
Message-ID: <7glt0q$3fb$1@fir.prod.itd.earthlink.net>

I do not think that Oracle likes you committing in Trigger logic, even if the trigger call a stored object.

+-----------------------------+-----------------------------+
| R. Steven Brown			|	Best Consulting		|
| rstevenbrown_at_earthlink.net	|	1100 East 6600 South	|
| stevenb_at_bestnet.com		|	Suite 200			|
|					|	Salt Lake City UT 84121	|
| "When in danger, or in doubt|	(801) 266-6138 - Office |
|  Run in Circles, Scream and	|	(801) 266-0069 - Fax	|
|  Shout!" Lazarus Long		|	http://bestnet.com	|
+-----------------------------+-----------------------------+

LUC San <luc_san_at_hotmail.com> wrote in message news:3DeX2.5815$Ie6.2278166_at_WReNphoon4...
>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) **** Received on Mon May 03 1999 - 23:28:02 CDT