How does Piper trace output from a PL/SQL procedure that is not yet finished?
The most effective way of tracing a running PL/SQL procedure (or an anonymous block) is to write to an Oracle pipe using the DBMS_PIPE package. This provides an asynchronous, transaction-independent communication mechanism. Piper lets you write and run a fragment of PL/SQL that reads from such an Oracle Pipe, and lets you run this fragment in a loop repeatedly, thus allowing you to trace and debug your PL/SQL code, or to set up a live dynamic pipe-based roduction report facility.
Related Questions
- What are the two mandatory parameters required for PL/SQL stored Procedure Concurrent Program?
- What are the two mandatory parameters required for PL/SQL stored Procedure Concurrent Program?
- Does Oracle SQLJ support PL/SQL BOOLEAN, RECORD, and TABLE types as input and output parameters?
- How does Piper trace output from a PL/SQL procedure that is not yet finished?
- How can u create a table in PL/SQL procedure?
- How can u create a table in PL/SQL procedure?
