PG_READ action
Related pages:
PG_READ handleIdent_Int, pageNrIdent_Int, locVarArrIdent, retCodeIdent_Int
handleIdent_Int | in | Identifier of the Int type (handle) of the connection to a table (returned by the action PG_CONNECT). |
pageNrIdent_Int | in | Identifier of the Int type of required page number (from 1 …). |
locVarArrIdent | out | Identifier local variable of the Record type (whole structure) - read result. |
retCodeIdent_Int | out | Identifier of the Int type - action success. |
pageNrIdent_Int
. Pages in the table are numbered from one (1 ...). The performance of SQL expression SELECT for Oracle, stated in PG_CONNECT, can be influenced by using the Oracle SQL hint (parameter in PG_CONNECT).retCodeIden_Int =
_ERR_NO_ERROR
), then the reading result (required page) is assigned to the local variable locVarArrIdent_Int
. In case of need, the local variable array size is changed. The structure type of the local variable must be equal with the type of the table. If the reading result is empty data (the error _ERR_NO_DATA), the local array will be resized to the size of 0. Related pages:
Pridať komentár