The Integration Service cannot convert a String port from the External Procedure transformation to a Date/Time input port in the external procedure. The string is not in the default date format (MM/DD/YYYY HH24:MI:SS).
Use TO_DATE with the appropriate format string to convert a string to a date.
The Integration Service cannot convert data from an external procedure Date/Time output port to a String port in the External Procedure transformation.
Change the External Procedure transformation port to Date/Time.
ASK INFAPreview
