I am trying to pass the partition name as an in-out parameter in IICS.
select * from xyz partition('$$p_partition')
I am getting mostly [informatica][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended error. My param file is fine. I tested other parameters without any issues.
How can I pass the parameter successfully?