Dynamically update the column name in EPM Integration Agent Query
Summary:
is it possible to update the column name in the query using bind variable in PBCS for EPM Integration Agent/
Content (please ensure you mask any confidential information):
hi
we were trying to update the column name in the where clause of the query using bind variable. however we get error log below.
WHERE to_date(s.~squery~) >=~StartDate~
Oct-19 10:22:10:550 :: Error: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
Version (include the version you are using, if applicable):
24.10
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0