Re: Debug Oracle package - recommended Tools?
Date: Thu, 20 Sep 2001 11:33:10 +0100
Message-ID: <Zz2DU9AmXcq7EwlI_at_peterfinnigan.demon.co.uk>
Hi
You can use the oracle packages DBMS_DEBUG and DBMS_TRACE to debug PL/SQL, they are raw and hard to use but free as they are included in the RDBMS. They both involve setting up PL/SQL calls to the code being debugged, the concept is not harder than using gdb tho or dbx.
HTH
Pete Finnigan
www.pentest-limited.com
In article <GJvsJ5.3wF_at_news.boeing.com>, Muon Ngu <muonn_at_hotmail.com>
writes
>Hi,
>
>We're working on Oracle 8i server on Unix and Windows2000 clients and wonder
>what is/are good debug tools that we could use to debug Oracle packages.
>The one we use is Microsoft Visual Interdev gives us viewing to stored procs
>codes but not package.
>
>Is there a better tool to debug or just view package codes.
>
>Thanks,
>Muon
>
>
-- Pete Finnigan IT Security Consultant PenTest Limited Office 01565 830 990 Fax 01565 830 889 Mobile 07974 087 885 pete.finnigan_at_pentest-limited.com www.pentest-limited.comReceived on Thu Sep 20 2001 - 12:33:10 CEST