Functions | |
int | sqlo_prepare (sqlo_db_handle_t dbh, const char *stmt) |
Parse a statement. More... | |
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. More... | |
int | sqlo_bind_ref_cursor (sqlo_stmt_handle_t sth, const char *cursor_name, int *sth2p) |
Bind a REF CURSOR. More... | |
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. More... | |
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. More... | |
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. More... | |
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. More... | |
int | sqlo_define_ntable (sqlo_stmt_handle_t sth, unsigned int pos, int *sth2p) |
Define a nested table Please visit the example for details. More... | |
int | sqlo_execute (sqlo_stmt_handle_t sth, unsigned int iterations) |
Execute a statement. More... |
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, sqlo_execute 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 sqlo_open2. 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.
|