PG_CONNECT dbObjIdent, accessIdent_Int, handleIdent_Int, pgSizeIdent_Int, whereIdent_Str, orderByIdent_Str, rowsCountIdent_Int, retCodeIdent_Int [TRANS transHandle_Int] [MODE mode_Int] [ORAHINT hintIdent_Str] |
dbObjIdent | in | Reference to an object of Database table type. |
accessIdent_Int | in | Value identifier: required access to the table (_DB_READ, _DB_MODIFY). |
handleIdent_Int | out | Identifier for an unique number (handle) of the connection to the table. |
pgSizeIdent_Int | in | Identifier to determine maximal page size. |
whereIdent_Str | in | Identifier of Text type. Condition to select from the table. |
orderByIdent_Str |
in |
Identifier of Text type. Sorting in the final selection. |
rowsCountIdent_Int | out | Identifier of Int type. The number of rows in the selection. |
retCodeIdent_Int | out | Return code identifier. |
transHandle_Int | in | Identifier for an unique number (handle) for the connection to the database. |
mode_Int | in | Identifier of Int type - 0/1. |
hintIdent_Str | in | Expression of String type that defines Oracle SQL hint.
It is used as an instruction for the performance optimizer of SQL
command. The value is used without the opening and
terminating characters /*+ <orahint>
*/. The example is mentioned here. Note: In this situation, Oracle SQL hint is used for ESL action PG_READ, because in ESL action SQL_CONNECT SELECT expression is compounded for next called ESL action PG_READ. |
whereIdent_Str
. This text (a value
of the identifier whereIdent_Str
) is used in the clause
WHERE in the SQL command. orderByIdent_Str
.
The value of the identifier is used in the clause
ORDER BY in the SQL command.