Error in Date Conversion from Oracle Timestamp(6) to Local Variable Datetime

[former_member214776]

Hi All,

The data in ETL_USER_* tables is loaded from a spreadsheet and these tables are created in Oracle Database.

END_EXTRACT_DATE - timestamp(6)

A custom function is created which uses the data in ETL_TABLES and stores them in a Local Variable of type datetime.

$LV_ReturnDate = lookup_ext([ODS_DS.ODS.ETL_EXTRACT_CONTROL_PARM,'PRE_LOAD_CACHE','MAX'], [END_EXTRACT_DATE],[NULL],[CONFIG,'=',current_system_configuration(),SOURCE_SYSTEM,'=',$PV_SourceSystem]) SET ("run_as_separate_process"='no', "output_cols_info"='<?xml version="1.0" encoding="UTF-8"?><output_cols_info><col index="1" expression="no"/> </output_cols_info>' ) ; RETURN $LV_ReturnDate;

The value stored in Local variable is as such- 2000.??.?? ??:??:??.000000000

Attached-

Screenshot of Table Desc in Oracle,

Custom Function, Warning on Job Execution

warning.pnglocal-variable.pngcustom-function.pngetl-user-extract-entity.png