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
Anonymous PL/SQL Block
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Anonymous PL/SQL Block
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
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
For posterity :D
Code: Select all
BEGIN
DECLARE
..
BEGIN
...
END;
END;
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.