Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NVARCHAR2 gives error with Oracle8.1.7

Re: NVARCHAR2 gives error with Oracle8.1.7

From: sybrandb <sybrandb_at_gmail.com>
Date: 17 Apr 2007 04:46:52 -0700
Message-ID: <1176810411.998404.169420@n76g2000hsh.googlegroups.com>


On Apr 17, 1:20 pm, sachin_..._at_yahoo.com wrote:
> Hi,
>
> I have written a C application using OCI8.1.7 API to work with Oracle
> Unicode Data Types NVARCHAR2. On executing the application, I receive
> following error
>
> ORA-03113: end-of-file on communication channel.
>
> But the same application works with OCI9. Does that mean OCI8 does not
> support 'N' data types? If it does then what is reason of the above
> error.
>
> Any response in this regard will be helpful.

Oracle has altered national characterset names, and reduced the number of national charactersets in 9i. I would recommend looking in the globalization manual for both versions, whether your characterset is valid in both versions.
v$nls_valid_values will show you which values are possible. Apart from that ora-3113 can point to almost anything and requires a search on Metalink.
Note that 8.1.7 is desupported for quite some time, and 9i will follow soon.

--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Apr 17 2007 - 06:46:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US