Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01843: not a valid month Error
ORA-01843: not a valid month Error [message #252600] Thu, 19 July 2007 06:25 Go to next message
rkulasek
Messages: 15
Registered: April 2006
Junior Member
Hi

I get the following error message intermittently.
===> ORA-01843: not a valid month

The problem is only intermittent! Which makes this more difficult to solve !

Ideas please ?
The piece of problematic ProC code is given below -

===
if(nForUpdate)
{
EXEC SQL SELECT * into :dbtbl:dbind FROM MYTABLE
WHERE my_time = :dbtbl.my_time
AND myf_id = :dbtbl.myf_id
AND myl_id = :dbtbl.myl_id
AND myw_id = :dbtbl.myw_id
FOR UPDATE;
}
else
{
EXEC SQL SELECT * into :dbtbl:dbind FROM MYTABLE
WHERE my_time = :dbtbl.my_time
AND myf_id = :dbtbl.myf_id
AND myl_id = :dbtbl.myl_id
AND myw_id = :dbtbl.myw_id;
}

Raja
Re: ORA-01843: not a valid month Error [message #252606 is a reply to message #252600] Thu, 19 July 2007 06:50 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe the definition and its type of your variable should be useful.
Maybe the description of your table and its column types should be useful.

Most often "ORA-01843: not a valid month" is due to an implicit conversion string<->date.

Regards
Michel
Previous Topic: How to UPDATE a table A base on table B condition matched with table A?
Next Topic: logic in single SQL query
Goto Forum:
  


Current Time: Sun Dec 11 07:59:00 CST 2016

Total time taken to generate the page: 0.07769 seconds