Class: OCISvcCtx
Instance Method Summary collapse
- #break ⇒ Object
- #close_all_files ⇒ Object
-
#commit(*args) ⇒ Object
begin — OCISvcCtx#commit() commit the transaction.
-
#describeAny(vdsc, vname, vtype) ⇒ Object
THIS WILL BE DELETED IN FUTURE RELEASE.
-
#logoff ⇒ Object
begin — OCISvcCtx#logoff() disconnect from Oracle.
-
#passwordChange(*args) ⇒ Object
begin — OCISvcCtx#passwordChange(username, old_password, new_password [, mode]) :username the username.
- #pid ⇒ Object
- #release ⇒ Object
- #reset ⇒ Object
-
#rollback(*args) ⇒ Object
begin.
-
#version ⇒ Object
begin — OCIServer#version() get server version.
Methods inherited from OCIHandle
#attrGet, #attrSet, #free, new
Instance Method Details
#break ⇒ Object
158 159 160 161 162 163 164 165 166 167 168 |
# File 'ext/oci8/server.c', line 158
VALUE oci8_break(VALUE self)
{
oci8_handle_t *h;
sword rv;
Get_Handle(self, h); /* 0 */
rv = OCIBreak(h->hp, h->errhp);
if (rv != OCI_SUCCESS)
oci8_raise(h->errhp, rv, NULL);
return self;
}
|
#close_all_files ⇒ Object
170 171 172 173 174 175 176 177 178 179 180 181 |
# File 'ext/oci8/svcctx.c', line 170
static VALUE oci8_close_all_files(VALUE self)
{
oci8_handle_t *h;
sword rv;
Get_Handle(self, h); /* 0 */
rv = OCILobFileCloseAll(h->hp, h->errhp);
if (rv != OCI_SUCCESS) {
oci8_raise(h->errhp, rv, NULL);
}
return self;
}
|
#commit(*args) ⇒ Object
begin
commit the transaction.
:flags
((|OCI_DEFAULT|)) or ((|OCI_TRANS_TWOPHASE|)).
Default value is ((|OCI_DEFAULT|)).
correspond native OCI function: ((|OCITransCommit|))
end
101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 |
# File 'ext/oci8/svcctx.c', line 101
static VALUE oci8_trans_commit(int argc, VALUE *argv, VALUE self)
{
VALUE vflags;
oci8_handle_t *h;
ub4 flags;
sword rv;
rb_scan_args(argc, argv, "01", &vflags);
Get_Handle(self, h); /* 0 */
Get_Int_With_Default(argc, 1, vflags, flags, OCI_DEFAULT); /* 1 */
rv = OCITransCommit(h->hp, h->errhp, flags);
if (rv != OCI_SUCCESS) {
oci8_raise(h->errhp, rv, NULL);
}
return self;
}
|
#describeAny(vdsc, vname, vtype) ⇒ Object
THIS WILL BE DELETED IN FUTURE RELEASE.
150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 |
# File 'ext/oci8/svcctx.c', line 150
static VALUE oci8_describe_any(VALUE self, VALUE vdsc, VALUE vname, VALUE vtype)
{
oci8_handle_t *h;
oci8_handle_t *dsch;
oci8_string_t name;
ub1 type;
sword rv;
Get_Handle(self, h); /* 0 */
Check_Handle(vdsc, OCIDescribe, dsch); /* 1 */
Get_String(vname, name); /* 2 */
type = FIX2INT(vtype); /* 3 */
rv = OCIDescribeAny(h->hp, h->errhp, name.ptr, name.len, OCI_OTYPE_NAME, OCI_DEFAULT, type, dsch->hp);
if (rv != OCI_SUCCESS) {
oci8_raise(h->errhp, rv, NULL);
}
return self;
}
|
#logoff ⇒ Object
begin
— OCISvcCtx#logoff()
disconnect from Oracle.
If you use ((<OCIServer#attach>)) and ((<OCISession#begin>)) to logon,
use ((<OCIServer#detach>)) and ((<OCISession#end>)) instead.
See also ((<Simplified Logon>)) and ((<Explicit Attach and Begin Session>)).
correspond native OCI function: ((|OCILogoff|))
end
35 36 37 38 39 40 41 42 43 44 45 46 |
# File 'ext/oci8/svcctx.c', line 35
static VALUE oci8_svcctx_logoff(VALUE self)
{
oci8_handle_t *h;
sword rv;
Get_Handle(self, h); /* 0 */
rv = OCILogoff(h->hp, h->errhp);
if (rv != OCI_SUCCESS)
oci8_raise(h->errhp, rv, NULL);
return self;
}
|
#passwordChange(*args) ⇒ Object
begin
— OCISvcCtx#passwordChange(username, old_password, new_password [, mode])
:username
the username.
:old_password
old password of the user.
:new_password
new password of the user.
:mode
((|OCI_DEFAULT|)) or ((|OCI_AUTH|)). Default value is ((|OCI_DEFAULT|)).
For most cases, use default value. If you want to know detail,
see "Oracle Call Interface Programmer's Guide".
correspond native OCI function: ((|OCIPasswordChange|))
end
66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
# File 'ext/oci8/svcctx.c', line 66
static VALUE oci8_password_change(int argc, VALUE *argv, VALUE self)
{
VALUE vusername, vopasswd, vnpasswd, vmode;
oci8_handle_t *h;
oci8_string_t username, opasswd, npasswd;
ub4 mode;
sword rv;
rb_scan_args(argc, argv, "31", &vusername, &vopasswd, &vnpasswd, &vmode);
Get_Handle(self, h); /* 0 */
Get_String(vusername, username); /* 1 */
Get_String(vopasswd, opasswd); /* 2 */
Get_String(vnpasswd, npasswd); /* 3 */
Get_Int_With_Default(argc, 4, vmode, mode, OCI_DEFAULT); /* 4 */
rv = OCIPasswordChange(h->hp, h->errhp, username.ptr, username.len,
opasswd.ptr, opasswd.len, npasswd.ptr, npasswd.len, mode);
if (rv != OCI_SUCCESS) {
oci8_raise(h->errhp, rv, NULL);
}
return self;
}
|
#pid ⇒ Object
183 184 185 186 187 188 189 |
# File 'ext/oci8/svcctx.c', line 183
static VALUE oci8_pid(VALUE self)
{
oci8_handle_t *h;
Get_Handle(self, h); /* 0 */
return INT2FIX(h->u.svcctx.pid);
}
|
#release ⇒ Object
143 144 145 146 147 148 149 150 151 152 153 154 155 |
# File 'ext/oci8/server.c', line 143
VALUE oci8_server_release(VALUE self)
{
oci8_handle_t *h;
OraText buf[1024];
ub4 version = 0;
sword rv;
Get_Handle(self, h); /* 0 */
rv = OCIServerRelease(h->hp, h->errhp, buf, sizeof(buf), h->type, &version);
if (rv != OCI_SUCCESS)
oci8_raise(h->errhp, rv, NULL);
return rb_ary_new3(2, INT2FIX(version), rb_str_new2(buf));
}
|
#reset ⇒ Object
171 172 173 174 175 176 177 178 179 180 181 |
# File 'ext/oci8/server.c', line 171
VALUE oci8_reset(VALUE self)
{
oci8_handle_t *h;
sword rv;
Get_Handle(self, h); /* 0 */
rv = OCIReset(h->hp, h->errhp);
if (rv != OCI_SUCCESS)
oci8_raise(h->errhp, rv, NULL);
return self;
}
|
#rollback(*args) ⇒ Object
begin
rollback the transaction.
:flags
((|OCI_DEFAULT|)) only valid. Default value is ((|OCI_DEFAULT|)).
correspond native OCI function: ((|OCITransRollback|))
end
131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 |
# File 'ext/oci8/svcctx.c', line 131
static VALUE oci8_trans_rollback(int argc, VALUE *argv, VALUE self)
{
VALUE vflags;
oci8_handle_t *h;
ub4 flags;
sword rv;
rb_scan_args(argc, argv, "01", &vflags);
Get_Handle(self, h); /* 0 */
Get_Int_With_Default(argc, 1, vflags, flags, OCI_DEFAULT); /* 1 */
rv = OCITransRollback(h->hp, h->errhp, flags);
if (rv != OCI_SUCCESS) {
oci8_raise(h->errhp, rv, NULL);
}
return self;
}
|
#version ⇒ Object
begin
— OCIServer#version()
get server version.
:return value
string of server version. For example
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
correspond native OCI function: ((|OCIServerVersion|))
end
110 111 112 113 114 115 116 117 118 119 120 121 |
# File 'ext/oci8/server.c', line 110
VALUE oci8_server_version(VALUE self)
{
oci8_handle_t *h;
OraText buf[1024];
sword rv;
Get_Handle(self, h); /* 0 */
rv = OCIServerVersion(h->hp, h->errhp, buf, sizeof(buf), h->type);
if (rv != OCI_SUCCESS)
oci8_raise(h->errhp, rv, NULL);
return rb_str_new2(TO_CHARPTR(buf));
}
|