Skip to Content
0

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

Nov 09, 2016 at 07:19 AM

31

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers