home | O'Reilly's CD bookshelfs | FreeBSD | Linux | Cisco | Cisco Exam    

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










Previous: 11.7 A Programmatic Cursor FOR Loop Advanced Oracle PL/SQL Programming with Packages Next: 12. PLVio: Reading and Writing PL/SQL Source Code
11.7 A Programmatic Cursor FOR Loop Book Index 12. PLVio: Reading and Writing PL/SQL Source Code

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference










??????????????@Mail.ru