Webmaster Forum / ColdFusion / Advanced Techniques / August 2005

I am getting this err.Note:sometimes the same insert statement works fine..

Error Executing Database Query.  
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01843: not a valid month  
 
The error occurred in D:\CFusionMX\wwwroot\Calendar\add\addres.cfm: line 8
 
6 : <Cfquery datasource="#dsn#" name="newmeet">
7 : INSERT INTO cfr_meeting (CFR_MEETING_SEQ,StartHour, EndHour, datebox,
roomext, contact, phone, subject, status, bcontact, bphone)
8 : VALUES (CFR_MEETING_SEQ.nextval,'#TIMEFORMAT(starthour,
'hh:mmtt')#','#TIMEFORMAT(endhour, 'hh:mmtt')#', '#DATEFORMAT(datebox,
'DD-MMM-YYYY')#','#roomext#','#contact#', '#PHONE#','#Subject#',
'APPROVED','#bcontact#','#bphone#')
9 : </cfquery>
10 : </cftransaction>

 


--------------------------------------------------------------------------------
 
SQL    INSERT INTO cfr_meeting (CFR_MEETING_SEQ,StartHour, EndHour, datebox,
roomext, contact, phone, subject, status, bcontact, bphone) VALUES
(CFR_MEETING_SEQ.nextval,'08:30AM','09:30AM', '31-Aug-2005','7236','vozturk',
'6711','fgfgfg', 'APPROVED','forms','6712')  
DATASOURCE   Oracle9i_OtherForms
VENDORERRORCODE   1843
SQLSTATE   HY000