Actually discovered that there is a problem with
Oracle9i new Timestamp data type. The application
worked fine with Oracle9i's JDBC driver. However,
Weblogic6.1sp2's Oracle jDriver does not recognized
Oracle9i's new Timestamp datatype(s), so an error was
occuring in Weblogic's driver. To resolve the
problem, it was agreed internally to use the Date type
instead since use of the Timestamp wasn't absolutely
mandatory and we are unfortunately confined to using
Weblogic6.1sp2's Oracle jDriver.
--- Konrad <[EMAIL PROTECTED]> wrote:
> Has anyone ever encountered an ORA-00932 error when
> executing a simple OQL SELECT query when using
> Weblogic6.1sp2's Oracle JDBC driver? The query
> works
> fine on my local box, which uses the JDBC driver
> from
> Oracle. However, when deploying the application to
> our development server, which uses Weblogic6.1sp2's
> "special" Oracle (OCI) JDBC driver, I'm getting:
>
> "Nested error: java.sql.SQLException: Error while
> trying to retrieve text for error ORA-00932 while
> executing SELECT
>
"A"."ENTRY_SEQ_NUM","A"."PRTCPNT_ID","A"."CARD_ISSR_TXT","A"."PURCH_AMT_TXT","A"."CRSE_TXT","A"."ADV_TEXT","A"."ACC_TYP_TXT","A"."ENTRY_TS"
> FROM "A" WHERE ("A"."PRTCPNT_ID" = ?)
>
> and "?" can be any number.
>
> Any idea why this is happening?
>
> Thank you!!!
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
