Home » Developer & Programmer » Forms » ORA-01841
ORA-01841 [message #285993] Thu, 06 December 2007 04:37 Go to next message
kuwait
Messages: 52
Registered: October 2007
Member
Hi all

I have a data block with the following where clause
(TNCDATE >= TO_DATE( '01/04/:CB.YER' ))
 AND
(TNCDATE <= TO_DATE( '31/03/(:CB.YER+1)' ))

When i run it gave the msg unable to perform query and this was the error:
"ORA-01841: (full) year must be between -4713 and +9999, and not be 0"

- CB.YER is a char that ranges from 03 to 07(current year)

Please can you help me?
Thanks

[Updated on: Thu, 06 December 2007 04:38]

Report message to a moderator

Re: ORA-01841 [message #285998 is a reply to message #285993] Thu, 06 December 2007 04:54 Go to previous message
kuwait
Messages: 52
Registered: October 2007
Member
Thanks all I've solved the problem

This is my solution:
(TNCDATE>=TO_DATE('01/04/'||:CB.YER,'dd/mm/yy'))
 and
(TNCDATE<=TO_DATE('31/03/'||(:CB.YER+1),'dd/mm/yy'))
Previous Topic: Field Validation
Next Topic: Procedure on alter user [MERGED]
Goto Forum:
  


Current Time: Mon Dec 05 05:08:02 CST 2016

Total time taken to generate the page: 0.05833 seconds