Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date insertion error
Yousaf <noway_at_hose.com> wrote:
>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
I suspect that OLEDB is not getting the sysdate( there may be a ASP function you need to use instead)- Try using an actual date ( formatted correctly fro Oracle) instead, and see if you still get the error.
hth, Received on Mon Nov 24 2003 - 13:01:18 CST