GitHub user sivaguru-rajasekaran added a comment to the discussion: Oracle
Table Input with variables (${LAST_RUN_TS}, ${LAST_RUN_ID}) failing in Apache
Hop
Hop version-2.16.0
Oracle DB version-Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Oracle JDBC driver used-oracle.jdbc.OracleDriver
CREATE TABLE ETL_TABLE_CONTROL (
TABLE_NAME VARCHAR2(128) NOT NULL,
LAST_RUN_TS TIMESTAMP(9),
STATUS VARCHAR2(20),
LAST_RUN_ID NUMBER,
ROW_COUNT NUMBER,
ERROR_CODE VARCHAR2(100),
ERROR_MESSAGE VARCHAR2(4000),
FROM_TS TIMESTAMP(6),
TO_TS TIMESTAMP(6),
CONSTRAINT PK_ETL_TABLE_CONTROL
PRIMARY KEY (TABLE_NAME)
);
INSERT INTO ETL_TABLE_CONTROL (
TABLE_NAME,
LAST_RUN_TS,
STATUS,
LAST_RUN_ID,
ROW_COUNT,
FROM_TS,
TO_TS
)
VALUES (
'XXSIFY_CPQ_ORDER_DETAILS_UDM',
TO_TIMESTAMP(
'31-12-25 03:13:55.000000000 PM',
'DD-MM-RR HH:MI:SS.FF9 AM'
),
'INIT',
92582,
0,
TIMESTAMP '2025-12-28 11:37:34',
TIMESTAMP '2025-12-30 11:37:34'
);
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15380820
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
