Data Fields | |
NUMBER | I1 |
generic integer parameter, usually an index | |
NUMBER | I2 |
generic integer parameter | |
NUMBER | I3 |
generic integer parameter | |
NUMBER | I4 |
generic integer parameter | |
NUMBER | I5 |
generic integer parameter | |
NUMBER | I6 |
generic integer parameter | |
NUMBER | I7 |
generic integer parameter | |
NUMBER | I8 |
generic integer parameter | |
VARCHAR2[512] | S1 |
string parameter; typically contains a device name | |
VARCHAR2[512] | S2 |
string parameter | |
VARCHAR2[256] | S3 |
string parameter | |
VARCHAR2[256] | S4 |
string parameter | |
VARCHAR2[256] | S5 |
string parameter | |
VARCHAR2[256] | S6 |
string parameter | |
VARCHAR2[4000] | S7 |
long string parameter | |
VARCHAR2[4000] | S8 |
long string parameter | |
VARCHAR2[16] | S9 |
short string parameter | |
VARCHAR2[16] | S10 |
short string parameter | |
DATE | D1 |
date/time parameter, typicaly the start time (beginning of IOV) | |
DATE | D2 |
date/time parameter, typicaly the end time (end of IOV) | |
CLOB | C1 |
blob parameter |
CDB_API_PARAMS is a global temporary table used to pass the data from/to the PL/SQL functions contained in the package External access to ConfigurationDB (PL/SQL API) .
The table is used to pass the data which has a form of list of records, such as the list of device names, or a list of settings for a recipe, where device element is specified in one column, and the corresponding setting in another.
The fields in the table have no a`priori associated meaning, that is why their names are generic. Each function expects its input data to be present in certain columns, and delivers the output into certain columns - the actual assignment (or: meaning) for each column is provided in the description of each procedure.
Being a temporary table, CDB_API_PARAMS does not occupy disk space: it is created in the memory of the database server, and the data contained in it persist only within a session. That also means that separate database sessions (connected to the same database schema) will refer to their private instances of CDB_API_PARAMS, and will not see/alter the data in the instances belonging to other sessions.
The CDB_API_PARAMS table preserves it contents when a commit operation is performed. This is to be able to feed the results returned by one PL/SQL procedure as an input to another. A user should remember to truncate this table before calling a PL/SQL procedure, if he wants to assure the consistency of the data passed into the procedure, using the SQL statement:
DELETE FROM CDB_API_PARAMS;
NUMBER CDB_API_PARAMS::I1 |
generic integer parameter, usually an index
NUMBER CDB_API_PARAMS::I2 |
generic integer parameter
NUMBER CDB_API_PARAMS::I3 |
generic integer parameter
NUMBER CDB_API_PARAMS::I4 |
generic integer parameter
NUMBER CDB_API_PARAMS::I5 |
generic integer parameter
NUMBER CDB_API_PARAMS::I6 |
generic integer parameter
NUMBER CDB_API_PARAMS::I7 |
generic integer parameter
NUMBER CDB_API_PARAMS::I8 |
generic integer parameter
VARCHAR2 [512] CDB_API_PARAMS::S1 |
string parameter; typically contains a device name
VARCHAR2 [512] CDB_API_PARAMS::S2 |
string parameter
VARCHAR2 [256] CDB_API_PARAMS::S3 |
string parameter
VARCHAR2 [256] CDB_API_PARAMS::S4 |
string parameter
VARCHAR2 [256] CDB_API_PARAMS::S5 |
string parameter
VARCHAR2 [256] CDB_API_PARAMS::S6 |
string parameter
VARCHAR2 [4000] CDB_API_PARAMS::S7 |
long string parameter
VARCHAR2 [4000] CDB_API_PARAMS::S8 |
long string parameter
VARCHAR2 [16] CDB_API_PARAMS::S9 |
short string parameter
VARCHAR2 [16] CDB_API_PARAMS::S10 |
short string parameter
DATE CDB_API_PARAMS::D1 |
date/time parameter, typicaly the start time (beginning of IOV)
DATE CDB_API_PARAMS::D2 |
date/time parameter, typicaly the end time (end of IOV)
CLOB CDB_API_PARAMS::C1 |
blob parameter