Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NVARCHAR2 gives error with Oracle8.1.7
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 DBAReceived on Tue Apr 17 2007 - 06:46:52 CDT