I am taking in 3 fields from a flat file (all strings), taking them into an expression transf. in which i convert one of the fields to "date/time" using to_date (with the format mm/dd/yyyy) and keeping the others as strings, and then mapping them into stored procedure transformation (with 2 varchar2 and 1 date input ports). I then map the output of the stored proc into the target (another flat file).
I get a "database driver error" when I run the workflow and the log says that "I am passing in the wrong number of arguments or the wrong data types into the stored proc".
I am assuming that Oracle server (which actualy has the stored proc) doesn't like the date I am passing into the stored proc considering that oracle's default date format is "dd-mon-yy" and the date I am passing in is mm/dd/yyyy. Any suggestions?
Thanks
I get a "database driver error" when I run the workflow and the log says that "I am passing in the wrong number of arguments or the wrong data types into the stored proc".
I am assuming that Oracle server (which actualy has the stored proc) doesn't like the date I am passing into the stored proc considering that oracle's default date format is "dd-mon-yy" and the date I am passing in is mm/dd/yyyy. Any suggestions?
Thanks