Capture PL/SQL anonymous block data and write to a flat file

[sgubba]

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

[chulett]

You certainly can. Have you been through Chapter 6 of the Connectivity Guide for Oracle Databases pdf? There's lots of information there on using PL/SQL in the connector and the requirements around that topic.