start page | rating of books | rating of authors | reviews | copyrights

Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 5.28 PLVtrc: Trace Facility Chapter 5
PL/Vision Package Specifications
Next: III. Building Block Packages
 

5.29 PLVvu: Code and Error Viewing

The PLVvu (PL/Vision View) package provides a set of programs that allow you to view both stored source code and compile errors. See Chapter 15, PLVvu: Viewing Source Code and Compile Errors for details.

5.29.1 Package constants

c_overlap INTEGER := 5;

The default and initial value for the number of lines to overlap around a line with a compile error.

5.29.2 Setting the overlap

PROCEDURE set_overlap (size_in IN INTEGER := c_overlap);

Call this procedure to change the size of overlap from the default described above. If you call set_overlap without any value, the size is set back to the default.

FUNCTION overlap RETURN INTEGER;

Returns the current number of overlap lines.

5.29.3 Displaying stored code

PROCEDURE code
(name_in IN VARCHAR2 := NULL,
start_in IN INTEGER := 1,
end_in IN INTEGER := NULL,
header_in IN VARCHAR2 := 'Code');

Displays some or all of the lines of source code for the specified object.

PROCEDURE code_after
(name_in IN VARCHAR2 := NULL,
start_with_in IN VARCHAR2,
num_lines_in IN INTEGER := overlap,
nth_in IN INTEGER := 1);

Displays some or all of the lines of source code for the specified object that come after the n th appearance of the specified string.

5.29.4 Displaying compile errors

PROCEDURE err
(name_in IN VARCHAR2 := NULL,
overlap_in IN INTEGER := overlap);

Displays the compile errors for the specified object, along with the immediately surrounding code. You can provide an override to the current number of overlap lines in the second argument.

PROCEDURE err (name_in IN VARCHAR2, type_in IN VARCHAR2);

Displays the compile errors for the specified object, along with the immediately surrounding code. In this version of err , you supply the program name and the program type separately (and rely on the default overlap). This is available primarily for backward compatibility to earlier versions of PLVvu.


Previous: 5.28 PLVtrc: Trace Facility Advanced Oracle PL/SQL Programming with Packages Next: III. Building Block Packages
5.28 PLVtrc: Trace Facility Book Index III. Building Block 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