Options

Getting error when Passed macro in Read database operator for comparison

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
Hello,

I have account_info_date in format "01/01/2016 00:00:00 AM IST"

SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
FROM FA_FIN_INDICATOR_COMPUTATION
WHERE INSTITUTION_ID=%{institution_id} and ACCOUNT_INFO_DATE=%{account_info_date}

Getting missing right parenthesis or SQL not ended properly error

Best Answer

  • Options
    jwpfaujwpfau Employee, Member Posts: 302 RM Engineering
    Solution Accepted
    Hi,

    can you try to put single quotes around the macros?
    SELECT INSTITUTION_ID,AMOUNT,PERIOD_INDICATOR,ACCOUNT_INFO_DATE
    FROM FA_FIN_INDICATOR_COMPUTATION 
    WHERE INSTITUTION_ID='%{institution_id}' AND ACCOUNT_INFO_DATE='%{account_info_date}'

    Greetings,
    Jonas
Sign In or Register to comment.