Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dealing with multi-byte character using OCI on HP-UX
Hi Frank,
The enviroment is Oracle Database 10g Release 10.1.0.2.0 64bit production on HP-UX, the server and client(my program) are on same box. I set three variables:
set ORACLE_HOME=/app/oracle/OraHome_1
set ORA_NLS33=/app/oracle/OraHome_1/nls/data
set NLS_LANG=japanese_japan.ja16sjis
Got a error message error message at OCILogon -- Error while trying to retrieve text for error ORA-12705.
A fragment of the program used to write data into database as follows.
text *sql = (text *) "insert into MESSAGELOG(\"DATE\", \"TIME\", " \
"TID, DIR, MLEN, MESSAGE) " \ " values(:cdate, :ctime, :tid, :dir, :len,:msg) ";
OCIStmtPrepare(oci_stmhp, oci_errhp, sql, (ub4)strlen((char *)sql),
(ub4)OCI_NTV_SYNTAX, (ub4)OCI_DEFAULT);
OCIBindByPos(oci_stmhp, &bnd1p, oci_errhp, 1, (dvoid *)cdate,
(sb4)cdlen,
SQLT_AFC, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
(ub4 *)0,
OCI_DEFAULT);
SQLT_AFC, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
(ub4 *)0,
OCI_DEFAULT);
OCIBindByPos(oci_stmhp, &bnd3p, oci_errhp, 3, (dvoid *)tid,
(sb4)tidlen,
SQLT_AFC, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
(ub4 *)0,
OCI_DEFAULT);
SQLT_AFC, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
(ub4 *)0,
OCI_DEFAULT);
SQLT_INT, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
(ub4 *)0,
OCI_DEFAULT);
SQLT_AFC, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
(ub4 *)0,
OCI_DEFAULT);
status = OCIStmtExecute(oci_svchp, oci_stmhp, oci_errhp, (ub4)1,
(ub4)0,
(CONST OCISnapshot *)NULL, (OCISnapshot *)NULL, OCI_DEFAULT);
Regards,
Jason.
Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cn7ed3$bea$3_at_news4.zwoll1.ov.home.nl>...
> Jason Liang wrote: > > At least state the version of Oracle (3 digits, 5 if possible), > and the exact error code (e.g. ORA-01017)Received on Sun Nov 14 2004 - 23:05:25 CST