Porovnávané verzie
porovnané s
Kľúč
- Tento riadok sa pridal
- Riadok je odstránený.
- Formátovanie sa zmenilo.
PG_INSERT action
Function
The action allows to insert inserting a row into the specified table.
Declaration
| Blok kódu | ||||
|---|---|---|---|---|
| ||||
PG_INSERT handleIdent_Int, rowIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] |
Parameters
| handleIdent_Int | in | Identifier of the Int type (handle) of the connection with a table (returned by the action PG_CONNECT). |
| rowIdent | in | One structure row identifier (the row to insert). |
| retCodeIdent_Int | out | Return value of the Int type - action success. |
| hintIdent_Str | in | Expression of the String type |
| which defines Oracle SQL hint. It is used as an instruction for the performance optimizer of the SQL command. The value is used without the opening and terminating characters /*+ <orahint> */. The example is mentioned here. |
Return code
The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.
Description
Table must be opened with the access _DB_MODIFY. The type of the inserted row must be correct. Values of all items of the inserted row must be valid and the structure type of the local variable must be equal to the table type.
For using the function on Microsoft SQL Server platform, there must be defined the primary key or at least unique index for a table from the platform. For the platform Sybase and Oracle, the function works without these limitations.
Related topics