Re: Dealing with multi-byte character using OCI on HP-UX

Problem solved. Just set three variables. Thank you very much.

setenv ORACLE_HOME /app/oracle/OraHome_1 setenv ORA_NLS33 /app/oracle/OraHome_1/nls/data setenv NLS_LANG japanese_japan.ja16sjis

Jason.

jsnliang_at_hotmail.com (Jason Liang) wrote in message news:<e35f0def.0411142105.46e3249_at_posting.google.com>...
> 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);
> OCIBindByPos(oci_stmhp, &bnd2p, oci_errhp, 2, (dvoid *)ctime,
> (sb4)ctlen,
> 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);
> OCIBindByPos(oci_stmhp, &bnd4p, oci_errhp, 4, (dvoid *)dir,
> (sb4)dirlen,
> SQLT_AFC, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
> (ub4 *)0,
> OCI_DEFAULT);
> t), OCIBindByPos(oci_stmhp, &bnd5p, oci_errhp, 5, (dvoid *)&blen,
> (sb4)sizeof(in
> SQLT_INT, (dvoid *)0, (ub2 *)0, (ub2 *)0, (ub4)0,
> (ub4 *)0,
> OCI_DEFAULT);
> OCIBindByPos(oci_stmhp, &bnd6p, oci_errhp, 6, (dvoid *)buff,
> (sword)len,
> 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 Mon Nov 15 2004 - 18:57:14 CET