Hello Doug,

Since I was forwarned that Execeute Procedure can cause problems,
I always had my procedures return at least a single field, something
like STATUS being set to 0 when a procedure executed ok.
Since then used SELECT STATUS FROM PROCEDURE (PARMS...) in triggers
and procedures and software interfaces. Never had a failure or a
warning restricting such usuage in a trigger. To at least return
something comes in very handy debugging your procedure
by setting the returned value to various values in various
sections of your coding.

Best Regards
Hans
-------------------------------------------------------
Doug Chamberlin wrote:

>
> At 10/6/2001 07:11 PM (Saturday), bossman@... wrote:
> >Got a table with fields in it. What i'd like to do is to put a vaue
> >into a field via a trigger (this is fine and can do it).
> >
> >what i want then to do is to do a commit retain so the value that was
> >just placed to appear on the screen (another words refresh the view).
>
> You cannot commit from within a stored procedure or trigger. Do this from
> your application after the SQL which invoked the trigger finishes.
>
> Use the EXECUTE PROCEDURE statement to run a stored procedure from within a
> trigger.
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/