I have an Oracle database table with datetime values stored in a VARCHAR column.
Some of the rows of data have null for the RECORD_START_TIME.
I am attempting to insert into a table with a TIMESTAMP(0) column.
This SQL runs fine outside of Talend DI, but it errors when I try running it in the tOracleRow component.
execute immediate 'INSERT /*+ append parallel (8) */ INTO myDatabase.myTable
CASE WHEN RECORD_START_TIME is null THEN null ELSE to_timestamp( RECORD_START_TIME,''yyyy-mm-dd HH24:MI:ss'' ) END as RECORD_START_TIME
execute immediate 'commit';
The error is:
ORA-01830: date format picture ends before converting entire input string
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.