Functions | |
int | sqlo_connect (sqlo_db_handle_t *dbhp, const char *cstr) |
Connect to a database. More... | |
int | sqlo_finish (sqlo_db_handle_t dbh) |
Finish the session. More... | |
int | sqlo_split_cstring (const char *cstr, char *uid, char *pwd, char *tnsname, unsigned int bufsize) |
Split an Oracle connect string. More... | |
int | sqlo_server_attach (sqlo_db_handle_t *dbhp, const char *tnsname) |
Attach to a database server. More... | |
int | sqlo_session_begin (sqlo_db_handle_t dbh, const char *username, const char *password) |
Begin a session. More... | |
int | sqlo_server_detach (sqlo_db_handle_t dbh) |
Detach from server. More... | |
int | sqlo_server_free (sqlo_db_handle_t dbh) |
Free a server connection This is your emergency exit when a connection to a database gets lost (end of file on communication channel). More... | |
int | sqlo_session_end (sqlo_db_handle_t dbh) |
End a session. More... | |
const char * | sqlo_getdatabase (sqlo_db_handle_t dbh) |
Returns the tnsname. More... |
|
Connect to a database. This is the short form of sqlo_server_attach followed by sqlo_session_begin
|
|
Finish the session. Finish the session with implicit commit. This is the short form of sqlo_session_end followed by sqlo_server_detach.
|
|
Returns the tnsname. Returns the tnsname (or service name) of the given dbh.
|
|
Attach to a database server. Attaches to a database without creating a session. tnsname can be a database name or a connect string. The function extracts the database name. If no database name is supplied, the function attaches to the database given in the env. variable ORACLE_SID.
|
|
Detach from server. Closes all open sessions and detaches from the server.
|
|
Free a server connection This is your emergency exit when a connection to a database gets lost (end of file on communication channel). You cannot free the libsqlora8 resources in such a case by sqlo_session_end or sqlo_server_detach, because the OCI statement OCISessionEnd crashes :-( So, if you detect that a connection is broken and you want to clean up the situation and reconnect, call sqlo_server_free to detach from the server and savely free the resources allocated by libsqlora8
|
|
Begin a session. Do the login to an attached server. You can either pass username and password seperatly, or pass the complete connect string in username.
|
|
End a session. Does a logout, but does not detach from the server. It is possible to create a new session via sqlo_session_begin.
|
|
Split an Oracle connect string. Splits an Oracle connect string of the form uid[[/pwd]@tnsname] into its components. If no tnsname is found in the cstr, we copy the value of the env. variable ORACLE_SID into tnsname.
|