Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 6.5 The Predefined DatatypesChapter 6
PLV: Top-Level Constants and Functions
Next: 7. p: A Powerful Substitute for DBMS_OUTPUT
 

6.6 The Predefined Constants

In addition to the predefined datatypes, the PLV package offers a set of constants that are used throughout PL/Vision. These constants define the type of input or output repository you want to use in a given situation. These constants are used in PLVio, PLVlog, and PLVexc. The input/output options in PL/Vision are shown in the following table.

Description

Constant

Database table

dbtab

PL/SQL table

pstab

Operating system file

file

VARCHAR2 string

string

Standard output

stdout

For example, if you want to define the target repository of the PLVio package to be a PL/SQL table, you will issue this command:

SQL> exec PLVio.settrg (PLV.pstab);

If you want PLVlog to write its information to an operating system file, you will execute this command:

SQL> exec PLVlog.tofile;

which in turn sets the v_log_type variable to the PLV.file constant.


Previous: 6.5 The Predefined DatatypesAdvanced Oracle PL/SQL Programming with PackagesNext: 7. p: A Powerful Substitute for DBMS_OUTPUT
6.5 The Predefined DatatypesBook Index7. p: A Powerful Substitute for DBMS_OUTPUT

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