running dynamic sqls

[vishu19aug]

Hi,

My DS job is creating the Insert statements dynamically. Due to bad design of DB everything in my job including Table name is dynamic. I need to execute these statements on Oracle DB in the parallel job. How can i do that, i tired using Db connector for Pl/SQL but i had to provide it the input file as parameter but not able to use the input stream as input to the DB conncetor.

Any Help is really appreciated.

Thanks

[ray.wurlod]

You could try generating the entire SQL in a previous (server?) job and providing it to your loading job as a parameter value.