Re: Intermittent java.sql.SQLException: ORA-00902: invalid datatype
From: joeNOSPAM_at_BEA.com <joe.weinstein_at_gmail.com>
Date: Thu, 12 Feb 2009 18:28:14 -0800 (PST)
Message-ID: <f6f904d7-f7b7-4ac0-beaf-da815f1ac8a1_at_j8g2000yql.googlegroups.com>
On Feb 12, 12:24 am, Suresh <eluri.sur..._at_gmail.com> wrote:
> Hi,
>
> We are getting java.sql.SQLException: ORA-00902: invalid datatype
> exception intermittently while saving the data in db using java, most
> of the times it is working for the same data elements,
>
> We are using Oracle SQL types to save the data in Oracle9i database!
>
> Please give some suggestions why we are getting this exception only in
> some times -?
Date: Thu, 12 Feb 2009 18:28:14 -0800 (PST)
Message-ID: <f6f904d7-f7b7-4ac0-beaf-da815f1ac8a1_at_j8g2000yql.googlegroups.com>
On Feb 12, 12:24 am, Suresh <eluri.sur..._at_gmail.com> wrote:
> Hi,
>
> We are getting java.sql.SQLException: ORA-00902: invalid datatype
> exception intermittently while saving the data in db using java, most
> of the times it is working for the same data elements,
>
> We are using Oracle SQL types to save the data in Oracle9i database!
>
> Please give some suggestions why we are getting this exception only in
> some times -?
It may depend on the particular data values, and it may have to do
with
something else entirely. Show the code. Where does it run? What
driver version are you using?
Received on Thu Feb 12 2009 - 20:28:14 CST