> there are tools/tricks that I can use in order to debug/trace triggers and
> SPs ?

There are number of tools of various cost, quality and sophistication listed
at
http://www.ibphoenix.com/ib_contrib_download.html

Regards
Paul