HI Divya,
Use ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; to set
proper date format. I think it is like this in forms you have date format as
mm-dd-yyyy and in database server date format is dd-mm-yyyy, or vice
versa. Using nls_date_format you can solve this problem.

Thanks & Regards
Mujeeb

-----Original Message-----
From: CarolinDivya
[mailto:oracledba-ezmlmshield-x54963323.[Email address protected]
Sent: Thursday, September 27, 2007 6:09 PM
To: LazyDBA Discussion
Subject: FW: Oracle error




-----Original Message-----
From: Kanagaraj, Carolin Divya (Cognizant)
Sent: Thursday, September 27, 2007 5:58 PM
To: LazyDBA Discussion
Subject: Oracle error

Hai ,

I am new to Oracle.

My client has specified an error FRM-40735 Form_StartUp trigger raised
unhandled exception ORA-01843.

I know this is due to the invalid month.
But in forms it wont accept if we give the wrong month.
How will that error occur in oracle FORMS?
And what is the solution to that?

Can anyone help me?

Regards,
Carolin Divya.K

This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly
prohibited and may be unlawful.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page