Re: How to DEBUG a trigger or procedure
Posted by:
Bob Field
Date: March 24, 2006 09:16AM
Just add SELECT statements:
SELECT 'Message Text' AS `Title`;
Or create a temporary table and insert messages into it. SELECT * from temptable at the end of your procdure or after you're back at the prompt.
Edited 1 time(s). Last edit at 03/24/2006 09:18AM by Bob Field.
Subject
Views
Written By
Posted
39488
March 24, 2006 04:08AM
Re: How to DEBUG a trigger or procedure
37881
March 24, 2006 09:16AM
22162
June 08, 2007 08:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.