Variables for Database Packages and Their Child Objects

PowerDesigner can use variables in the generation and reverse-engineering of database packages and their child objects.

The following variables are available for database packages:

Variable

Comment

%DBPACKAGE%

Generated code of the database package

%DBPACKAGECODE%

Initialization code at the end of the package

%DBPACKAGESPEC%

Database package specification

%DBPACKAGEBODY%

Database package body

%DBPACKAGEINIT%

Database package initialization code

%DBPACKAGEPRIV%

Database package authorization (old privilege)

%DBPACKAGEAUTH%

Database package authorization

%DBPACKAGEPUBLIC%

True for public sub-object

%DBPACKAGETEXT%

Database package body with ODBC

%DBPACKAGEHEADER%

Database package spec with ODBC

The following variables are available for database package procedures:

Variable

Comment

%DBPKPROC%

Procedure code

%DBPKPROCTYPE%

Procedure type (procedure, function)

%DBPKPROCCODE%

Procedure body (begin... end)

%DBPKPROCRETURN%

Procedure return type

%DBPKPROCPARAM%

Procedure parameters

The following variables are available for database package variables:

Variable

Comment

%DBPFVAR%

Variable code

%DBPFVARTYPE%

Variable type

%DBPFVARCONST%

Variable of constant type

%DBPFVARVALUE%

Variable default value for constant

The following variables are available for database package types:

Variable

Comment

%DBPKTYPE%

Type code

%DBPKTYPEVAR%

List of variables

%DBPKISSUBTYPE%

True if type is a subtype

The following variables are available for database package cursors:

Variable

Comment

%DBPKCURSOR%

Cursor code

%DBPKCURSORRETURN%

Cursor return type

%DBPKCURSORQUERY%

Cursor query

%DBPKCURSORPARAM%

Cursor parameter

The following variables are available for database package exceptions:

Variable

Comment

%DBPKEXEC%

Exception code

The following variables are available for database package parameters:

Variable

Comment

%DBPKPARM%

Parameter code

%DBPKPARMTYPE%

Parameter type

%DBPKPARMDTTP%

Parameter data type

%DBPKPARMDEFAULT%

Parameter default value

The following variables are available for database package pragmas:

Variable

Comment

%DBPKPRAGMA%

Pragma directive

%DBPKPRAGMAOBJ%

Pragma directive on object

%DBPKPRAGMAPARAM%

Pragma directive parameter