ORA-12704 using OCIBindByPos

From: hhac <hhac_at_my-deja.com>
Date: 2000/06/30
Message-ID: <8jiv42$pve$1_at_nnrp1.deja.com>#1/1


I am using OCI and I'm having trouble inserting a value into an NCHAR column. Here is my SQL statement: INSERT INTO Table1(NC)VALUES(:1)

I am using OCIBindByPos to bind the column. The 6th parameter's value is SQLT_AFC. Then I'm using OCIStmtExecute to execute the command and it's returning with the following error: Error - ORA-12704: character set mismatch

I tried using the following statement: INSERT INTO Table1(NC)VALUES (N:1) but it didn't work.

How do I insert into an NCHAR column using binding?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CEST

Original text of this message