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.

You must specify the PackageProcs parameter before connecting
to the database.
Controls
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
Syntax
1 |
PackageProcs=<span>value</span> |
Parameter |
Description |
---|---|
value |
Specifies that package-stored procedures
|
Default
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.DbParameter="PackageProcs=1"