Passing Oracle Table partition name as parameter in IICS

110 views Asked by At

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?

0

There are 0 answers