Re: PL/SQL as an alternative to C?
From: Michael P. Stein <mstein_at_access.digex.net>
Date: 8 Dec 1993 11:38:22 -0500
Message-ID: <2e4vtu$8d5_at_access.digex.net>
Date: 8 Dec 1993 11:38:22 -0500
Message-ID: <2e4vtu$8d5_at_access.digex.net>
Ken Matson <kdm_at_hebron.connected.com> wrote:
>In addition to the lack of I/O, the debugging capabilities with PL/SQL are
>non-existent.
What I ended up doing was creating a DEBUG table ( SEQNO NUMBER(6,0), DBG_TEXT VARCHAR2(255) ) and DEBUG_SEQ sequence to fill SEQNO. I put INSERT INTO DEBUG into the PL/SQL script at suitable waypoints to let me know what was going on. I just rolled back after looking at the contents of DEBUG - that way, I only saw my own debug messages, not those of any other developer. (Of course, you could also have a DEBUG table owned by each developer.)
-- Mike Stein The above represents the Absolute Truth. POB 10420 Therefore it cannot possibly be the official Arlington, VA 22210 position of my employer.Received on Wed Dec 08 1993 - 17:38:22 CET