PackageProcs
database parameter
Description
Specifies that the stored procedures and functions encapsulated in
an Oracle database package should be appended to the lists of Oracle
standalone stored procedures and functions displayed in the DataWindow
object and Database painters.
When to specify PackageProcs
You must specify the PackageProcs parameter before connecting to
the database.
Applies to
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
|
1 |
PackageProcs=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies that package-stored procedures and
|
Default value
PackageProcs=0
Usage
A package is an encapsulated collection of related program objects
(such as procedures, functions, variables, and cursors) stored together
in an Oracle database. Listing the objects contained in a package might
impose a performance penalty on your Oracle database connection. When
displayed in the DataWindow painter, only those objects that contain a
REF CURSOR or SELECT statement parameter are listed. When displayed in
the Database painter, all objects are listed. The text source displayed
is that of the entire package.
Examples
To specify that you want Oracle package objects appended to the
lists of stored procedures and functions:
-
Database profile
Select the List Package Subprograms check box on the System
page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="PackageProcs=1"