Re: ORA-17059

hmmm .. don't remember ever seeing that error. If you think that it is being caused by a particular data. Try finding out what data it is.
Then do this query in oracle:

select col_name, dump(col_name)
from the_table
where .... <appropriate where clause>
/

See if the data has non-us7ascii data in it?

Java... afaik .. works in ucs2 charset ... so it might be trying to convert the us7ascii data into ucs2 .. and fails in that. 17059 is a jdbc error code.

If you don't set nls_lang .. it should default to us7ascii in solaris.

Anurag

"Harry Sheng" <SHui1002_at_rogers.com> wrote in message news:DByd9.3646$3Lu1.71_at_news04.bloor.is.net.cable.rogers.com...
> Hi, Sybrand
>
> The error message says "Fail to convert to internal representation".
> What I really want to know is, fail to convert [what] to internal
> representation.
> I only find that ORA-17059 is a TTC adapter exception, and no other further
> information could be found from the net.
>
> So I can only guess that client and server use different character set,
> and at some point Oracle failed to convert one character set to the other.
>
> But how could this happen ? The character set used in server is US7ASCII,
> and none of those NLS parameters are set in the client environment. Besides,
> the client and server stay on the same Solaris8 box.
>
> Could you please kindly tell me what may cause this ORA-17059 error ?
>
> Thanks alot.
>
> Harry
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:mv1dnuk9hpp7cii7k3ucreg5katnpkfj3g_at_4ax.com...
> > On Wed, 4 Sep 2002 15:50:15 -0400, "Harry Sheng"
> > <hsheng_at_innovance.com> wrote:
> >
> > >What may cause an ORA-17059 exception ?
> > >I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
> > >My JDBC client and Oracle8i server are on the same box.
> > >
> > >Thanks in advance.
> > >
> >
> > I see you expect this group is going to look up the error text for
> > you.
> > You are mistaken in that.
> >
> > Regards
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Wed Sep 04 2002 - 22:37:39 CDT