Functions | |
int | sqlo_prepare (sqlo_db_handle_t dbh, const char *stmt) |
Parse a statement. | |
int | sqlo_bind_by_name (sqlo_stmt_handle_t sth, const char *name, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, int is_array) |
Bind a variable by name. | |
int | sqlo_bind_ref_cursor (sqlo_stmt_handle_t sth, const char *cursor_name, int *sth2p) |
Bind a REF CURSOR. | |
int | sqlo_bind_by_pos (sqlo_stmt_handle_t sth, int position, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, int is_array) |
Bind a variable by position. | |
int | sqlo_bind_by_pos2 (sqlo_stmt_handle_t sth, int position, int param_type, const void *param_addr, unsigned int param_size, short *ind_addr, unsigned short *rcode_addr, unsigned int skip_size) |
Bind a variable by position. | |
int | sqlo_define_by_pos (sqlo_stmt_handle_t sth, int value_pos, int value_type, const void *value_addr, unsigned int value_size, short *ind_addr, short *rlen_addr, int is_array) |
Define a output variable of the select list. | |
int | sqlo_define_by_pos2 (sqlo_stmt_handle_t sth, int value_pos, int value_type, const void *value_addr, unsigned int value_size, short *ind_addr, unsigned short *rlen_addr, unsigned short *rcode_addr, unsigned int skip_size) |
Define a output variable of the select list. | |
int | sqlo_define_ntable (sqlo_stmt_handle_t sth, unsigned int pos, int *sth2p) |
Define a nested table Please visit the example for details. | |
int | sqlo_execute (sqlo_stmt_handle_t sth, unsigned int iterations) |
Execute a statement. |
Use these functions if you want to execute PL/SQL or stored procedures.
|
Bind a variable by name. Use this to bind a variable in a query or a stored procedure call. If is_array is 1, the parameters param_addr and ind_addr must point to arrays. ind_addr is optional and can be passed a NULL. The param_size is still the size of one array element, not the whole array size!
|
|
Bind a variable by position. If is_array is 1, the parameters param_addr and ind_addr must point to arrays. ind_addr is optional and can be passed a NULL. The param_size is still the size of one array element, not the whole array size!
|
|
Bind a variable by position. Bind the input variables. This new version supports arrays of structures. Set the skip_size to the size of the structure. rcode and ind must be part of the structure.
|
|
Bind a REF CURSOR. Binds a ref cursor and returns a new sth, which you can use to retrieve the data.
|
|
Define a output variable of the select list. Use this to define the output variables. If is_array is 1, the parameters value_addr, rlen_addr and ind_addr must point to arrays. ind_addr is optional and can be passed a NULL. Passing NULL is only usefull for NOT NULL columns. If you ommit the indicator and a NULL is fetched, The advanced interface. will fail with an Oracle error (FETCHED COLUMN VALUE IS NULL). The value_size is still the size of one array element, not the whole array size!
|
|
Define a output variable of the select list. Use this to define where the result of the query should go. This new version supports filling arrays of structures. If skip_size is not 0, the parameter value_addr must point to an array of structures. If used, the structure must contain variables for ind, rlen and rcode. The value_size is still the size of one array element, not the whole array size!
|
|
Define a nested table Please visit the example for details.
|
|
Execute a statement. Execute a PL/SQL block or a statement after you prepared it with sqlo_prepare and bound input and output variables. If you are fetching into arrays, you can set iterations to the actual array size. For PL/SQL blocks it must be set to 1.
|
|
Parse a statement. This functions must be used to parse a statement if you want to bind manually the parameters. By doing this you can use native datatypes. This is the more complex form of The easy interface. If the stmt is a SELECT statement, the function sets the attribute OCI_ATTR_PREFETCH rows to the max arraysize parameter of the library. This is a kind of internal array fetch Oracle provides to speed up the fetching.
|