I have the following Golden Query that I am trying to and it is giving me this error message. When query is ran in Golden, it gives no issue. Only when put into the Execute Query activity:
Error message is :
Source: Execute Query
Message: ERROR  [Microsoft] [ODBC driver for Oracle][Oracle]ORA-00900: invalid SQL statement
Exception Type: System.Data.Odbc.OdbcException
Query being ran is this:
"DEFINE starttime = sysdate - 1
SELECT CUST_CD,FRM_SHPG_LOC_CD,TO_SHPG_LOC_CD, SHPM_NUM, SHPM_DESC, CRTD_DTT, PLAN_ID
CRTD_DTT > &&starttime
AND SHPM_NUM not like ‘SH-%’
AND CUST_CD = ‘FLNA’
order by CRTD_DTT desc"
Any help with this?