13.10 Tracing PLVfile Activity

Chapter 13
PLVfile: Reading and Writing Operating System Files
 

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.


13.9 Handling File Errors with PLVfileIV. Developer Utility Packages

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



Advanced Oracle PL. SQL Programming with Packages
Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
Year: 1995
Pages: 195
Authors: Steven Feuerstein, Debby Russell
BUY ON AMAZON

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net