11.8 Tracing PLVobj Activity

You can get feedback on activity in the PLVobj package by requesting that the trace be displayed. PLVobj offers a standard on-off toggle with the following three programs:

PROCEDURE display;
PROCEDURE nodisplay;
FUNCTION displaying RETURN BOOLEAN;

The default setting for PLVobj is no display.

In the following SQL*Plus session, I turn on the trace for PLVobj and then execute a script to see all the lines in PLVio that contain the keyword SUBSTR. The inline.sql program first calls PLVobj.setcurr and later calls PLVobj.bindobj . The first three lines after the call to inline.sql show that I called convobj , then set the current values, and finally performed a bind. The reason that the "convert" trace appeared is that setcurr calls convobj .

SQL>  exec PLVobj.display
SQL>  @inline b:PLVio SUBSTR
convert: Schema.Name.Type = "PLV.."
set: Schema.Name.Type = "PLV.PLVIO.PACKAGE BODY"
bind: Schema.Name.Type = "PLV.PLVIO.PACKAGE BODY"
Lines with SUBSTR in PLV.PLVIO.PACKAGE BODY
330
332
512