How to select Bind Variables from Oracle Input via ODBC

Question

Hello,

I have an existing long statement that relies on bind variables. ":Current_COB" and ":Prior_COB" in this case. What is the trick to inputting the dates I'm looking for in Alteryx? I tried dynamic input but I do not see a bind option.   Any help you could provide would be greatly appreciated.

Thanks!

SeanAdams · Answer

If you can avoid using bind variables - you can hard-replace :Current_COB in your SQL query with a literal value, and then put this dynamic SQL through your Dynamic Input tool.

Redlake19 · Answer

Just wanted to add that the current error message I receive on the input is this:

Error: Input Data (2): Error SQLExecute: [Oracle][ODBC][Ora]ORA-01008: not all variables bound