date insertion error

From: Yousaf <noway_at_hose.com>
Date: Mon, 24 Nov 2003 18:37:07 +0000
Message-ID: <1069698794.160704@ananke.eclipse.net.uk>

Hi,

I am developing an ASP VBScript app, and trying the following query via ASP code:

INSERT INTO RISK(RISK_NO, USER_ID, DESCRIPTION, RAISED_BY, LOG_DATE, IMPACT, OWNER, RESOLUTION, STATUS, EXPECTED_CLOSURE_DATE, CLOSED_DATE, ADDITIONAL_OWNER, OTHER_OWNER) VALUES(RISK_NOSeq.nextval, 'ROCKERM' ,'dsfda','HILLJE', SYSDATE, 'H', 'TOWDXX', '-','O', '09-AUG-1938', '09-AUG-1938', 'N', '-') And it is throwing up the following error:

Error Type:
OraOLEDB (0x80040E14)
ORA-01858: a non-numeric character was found where a numeric was expected

But the strange thing is, if I run the same query in SQL Plus, it inserts a record without throwing any error!

Could anyone shed some light on that?

Thanking you in advance

Regards

-- 
Yousaf
Linux version 2.4.20-8  
gcc version 3.2.2
Red Hat 9

Received on Mon Nov 24 2003 - 12:37:07 CST