We instrument our stored procedures with RAISE NOTICE statements, in what I think is a pretty standard approach to Netēzza Development.
However, Toad Data Point does not seem to support it at all. If I execute
CREATE OR REPLACE PROCEDURE TESTRAISENOTICE() RETURNS DATE LANGUAGE NZPLSQL AS
RAISE NOTICE ‘Towards thee I roll, thou all-destroying but unconquering whale’;
RAISE NOTICE ‘to the last I grapple with thee’;
RAISE NOTICE ‘from hell’‘s heart I stab at thee’;
RAISE NOTICE ‘for hate’‘s sake I spit my last breath at thee’;
DROP PROCEDURE TESTRAISENOTICE();
I don’t see even the first notice! I just get a bland ‘Executed Successfully.’ Where’s my Moby Dick?