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 |