I have a table where i store queries
my job is to read the table and execute the query and write the output to a flat file
for that i have a PL/SQL anonymous block that reads the table and execute the query using EXECUTE IMMEDIATE
I am able to run the PL/SQL anonymous block from connector stage but not able to collect the result and write to a file
I know there is a different approach where we can write the query to a flat file ..read the flat file and send the value as parameter in another datastage job
I am trying to know if we can capture the output of PL/SQL anonymous block when using connector stage and Read mode as PL/SQL
Appreciate your help
Capture PL/SQL anonymous block data and write to a flat file
Moderators: chulett, rschirm, roy