> Now, as I recall, you wrote this procedure as a selectable SP, i.e. you
> included a SUSPEND statement. If you plan to invoke this from other SPs or
> from triggers, you'll need to recreate it without the SUSPEND.

Or rewrite the trigger or SP to get values like:

SELECT <paramlist> FROM SP (PARAMS)

if they return a single row.

(If they return more than a single row you need a FOR SELECT ... LOOP,
which might not be what you wnat within a trigger)

I often use SELECTABLE procedures even if they return just one row (in
fact they are designed to _always_ return one row), since they have the
advantage that you can add new return params without recompiling
procedures that invoke them by EXECUTE PROCEDURE and don't need the new
return params.


Luc.