Help: - TRACE not working in stored procedure
Hi !
My stored procedure does not generate a TRACE file. I am using Informix
OWS 7.12 TC5 on a WinNT 4.0. I also tried using a APPEND TO with a
manually created trace file but still no success. Am I missing
something ? I am doing this using Informix SQL editor.
CREATE PROCEDURE trace_test( ) RETURNING CHAR (10);DEFINE junk CHAR(10);
SET DEBUG FILE TO 'foo.tra';
TRACE 'Start Trace';
TRACE ON;
LET junk = 'concat' || 'junk';
TRACE OFF;
RETURN junk;
END PROCEDURE
Would appreciate any pointers!
Thanks
Ravi