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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01843 ORA-02063 on OIAS 903

Re: ORA-01843 ORA-02063 on OIAS 903

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 02 Sep 2004 10:09:35 +0200
Message-ID: <ch6k35$5i6$1@news1.tilbu1.nb.home.nl>


Jochen wrote:

> Hello,
>
> suddenly it came the error on Oracle Application Server OIAS 903.
>
> Logger output:
>
> 2004-09-01 13:39:20,343 DEBUG ApplicationServerThread-8 (xxxDO:89) -
> Now excecute SQL: insert into xxx_T_FILE (bild_id, filetyp_id,
> pathmap_id, path, filename, fileformat_id, datum, updated) values
> (1094038760265, 6, 1, '1094038760265', 'PicABC_LR.jpg', 4,
> to_date('01.09.2004','dd.MM.yyyy'), 0)
>
>
> Always the statement and the application work fine. But know this
> error?
>
> 2004-09-01 13:39:20,359 ERROR ApplicationServerThread-8 (xxx:96) - SQL
> Exception
> java.sql.SQLException: ORA-01843: not a valid month
> ORA-02063: preceding line from xxx
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:241)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1477)
> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
>
>
> I restarted the services, OIAS and DB-Services. The same error. I
> donīt know, what is happen! If i execute the SQL-Statement with
> PL/SQL-Developer, it work fine! The app is running about 1 year know
> and the insert sql-statemnt works till now.
>
> Thank you for help and hints,
> Jochen

Where's the 8th argument? I don't see "updated" (which I presume to be a date, too) updated.
Probably the default date format was changed on the "client" (which would be the application server) - never manipulate dates without an explicit format.

-- 

Regards,
Frank van Bortel
Received on Thu Sep 02 2004 - 03:09:35 CDT

Original text of this message

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