on 07-21-2008 4:31 PM
Hi,
I'm trying to insert the following date and time into an oracle DB as part of a stored procedure
'2008-04-17 15:08:06' ..
In my mapping the target field is set to string with the attributes type = DATE and isInput = 1
I have to use the to_date function so I end up with this value....
TO_DATE('2008-04-17 15:08:06', 'YYYY-MM-DD HH24:MI:SS')
In the stored procedure the type is i_IssueDate is Date.
This doesn't work as I get this error: java.lang.NumberFormatException: For input string: "TO_DATE('2008"
I solved this problem.
I removed the TO_DATE function completely.
I set the attribute type to "TIMESTAMP"
Thats all that is requried!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.