Anonymous PL/SQL Block

[jerome_rajan]

Hi,

What is the best way to execute an anonymous PL/SQL block in a server job? Though the logic within this block can be implemented in a job, we are trying to minimize the number of stages to touch to reduce the re-wiring required since this is an existing job.

I tried to do it in the after sql in the Oracle stage but it couldn't read beyond
BEGIN..
Not sure what I should do with the stored procedure stage to execute an anonymous block.

Help appreciated. Thanks

[jerome_rajan]

Got it. It can be done using a Stored Procedure stage. But if the anonymous block has a declare section, then the block should be wrapped within another block of

Code: Select all

BEGIN
DECLARE
..
BEGIN
...
END;
END;

For posterity :D

[chulett]

[rameshrr3]

Are you trying to use it as a source or transform ? Are you using teh stored proc stage to process dat aon an input link and forward row data to an output link ? Just curious.