I am trying to insert into an Oracle table from a flat file by calling a service in IS but I am having a problem with a Date field. I first had a BrokerDate error in EAI (I created an insert operation in EAI). I got rid of this error after I unchecked the “Enable Script Security” checkbox which is checked by default in the Java tab, of the Adapter Configuation tool, for my Oracle adapter. Now, I am having another error:
ORA-01858 Non numeric character encountered when character was expected (or something like this)
:v1, :v2, :v3, :v4, :v4, :v5, TO_DATE(:v6, ‘yyyyMMdd’), :v7 etc v6 is the variable defined in EAI that corresponds to my Date field and that I want to be displayed in yyyyMMdd format.
When I don’t specify the format and just keep it like $(HIRE_DATE), a row is inserted in the table and the date value is something like 31/12/1899 when I try to insert a Date of Today.
Any help on how to fix this is greatly appreciated.