Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 13.9 Handling File Errors with PLVfileChapter 13
PLVfile: Reading and Writing Operating System Files
Next: IV. Developer Utility Packages
 

13.10 Tracing PLVfile Activity

PLVfile offers a standard PL/Vision toggle to allow you to dynamically turn on or off a trace of PLVfile activity. The triumvirate of programs for this toggle is:

PROCEDURE show;
PROCEDURE noshow;
FUNCTION showing;

When you call PLVfile.show, the trace is turned on (the default is that the trace is not active). Currently, PLVfile offers a trace of the get_line and put_line actions only.

It can be very frustrating to work with UTL_FILE and, by extension, PLVfile. You might think that you have taken all the necessary steps to perform file I/O, but you keep getting "Invalid Operation" errors. The PLVfile trace may well be able to give you the information you need to identify your problem more easily.


Previous: 13.9 Handling File Errors with PLVfileAdvanced Oracle PL/SQL Programming with PackagesNext: IV. Developer Utility Packages
13.9 Handling File Errors with PLVfileBook IndexIV. Developer Utility Packages

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