-
Hi,
Of course...
Here is a test case :
#include "ocilib.h"
int main(void)
{
OCI_Connection *cn;
OCI_Statement *st;
OCI_Initialize(NULL, NULL, OCI_ENV_CONTEXT);
cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);
st = OCI_StatementCreate(cn);
if (!OCI_ExecuteStmt(st...
2009-11-05 09:56:49 UTC in OCILIB - C Driver for Oracle
-
in order to use OCI_GetLastError(), you need to pass the flag OCI_ENV_CONTEXT to OCI_Initialize()....
2009-11-04 14:27:34 UTC in OCILIB - C Driver for Oracle
-
I reproduced it and will work on a patch ...
2009-10-30 16:34:30 UTC in OCILIB - C Driver for Oracle
-
Hi victor,
i've reproduced the problem (client 10.2 / server 10.2 on MS windows)
If a set any integer value to field ID, it works with no problem.
I've checked on metalink and found that's a bug of version 10.x (bug id : 3604465).
I've tested the same code with a client 9.2 against the same s10.2 server and it works well.
I've checked as well with a 11.1 client and it fails !!
So, it's...
2009-10-30 16:34:03 UTC in OCILIB - C Driver for Oracle
-
Hi,
No support yet.
but will be at some point
I need to setup a MST env to test it
Vincent.
2009-10-28 22:50:06 UTC in OCILIB - C Driver for Oracle
-
Hi,
OCI_BindUnsignedBigInt does not use a 32 bit variable internally.
It uses internally OCI structure OCINumber.
If you don't get the right value :
- check that your compiler handles long long as 64bits integer
- review your code
Bindings 64 integers works well in OCILIB and no issues have been reported about it. I've just tested again with VS2008 on Windows ans GCC on Linux and i got...
2009-10-28 22:47:18 UTC in OCILIB - C Driver for Oracle
-
Hi peter,
Sql*Plus asks you because it's an interactive program. OCILIB is just an API...
during the grace period, you can use OCI_SetPassword() to update the password.
I'll add a new function OCI_SetPassword2() that allow to change the password from any users (knowing his current password)
At the moment you can do an sql statement : alter user .....
I'll add as well a notion of...
2009-10-25 21:14:18 UTC in OCILIB - C Driver for Oracle
-
you need to pass the address of your big_int variable instread of the variable itself.
2009-10-24 17:59:21 UTC in OCILIB - C Driver for Oracle
-
hi Hoa,
It means you've allocated local objects that uses internal oci descriptors handles (such as lobs) and forgot to free them !
Vincent.
2009-10-18 18:40:46 UTC in OCILIB - C Driver for Oracle
-
to get the primary key (if key on multiple columns, it will return one row per column) :
select
column_name
from
user_constraints uc,
user_cons_columns ucc
where
uc.table_name = <table_name> and
uc.constraint_type = 'P' and
uc.constraint_name = ucc.constraint_name
order by
ucc.position;
to find out if a column...
2009-09-23 10:32:23 UTC in OCILIB - C Driver for Oracle