PL/SQL call stack ?

From: Jarek Palka <triss_at_zeus.polsl.gliwice.pl>
Date: Thu, 29 Apr 1999 08:35:12 +0200
Message-ID: <7g8uoa$ci6@router.kamsoft.com.pl>

Oracle server release 8.0.4 and above has capability of debugging stored procedures on server side. There are several tools (i.e. Procedure Builder, PL/SQL Developer) having build-in debugger: running step-by-step, breakpoints, call-stack, variables evaluation etc. I wonder know how can I get PL/SQL call stack from Oracle ? May be there is some dba_views storing such information ? Is it possible to recognize what procedure is processing at this moment from SELECT statement and what parameters it has?
I want to do PL/SQL trace and such info will be very useful.

Thanks,

Jarek Palka
Kamsoft, KATOWICE
POLAND Received on Thu Apr 29 1999 - 01:35:12 CDT