Automation Designer and DBMS_OUTPUT

Toad for Oracle
1

Is there any way to get Automation Designer to spool DBMS_OUTPUTs to the associated file when executing a script?

I have several scripts which get run across multiple instance schemas, the scripts have some debugging / checks using DBMS_OUTPUT, but even if I call DBMS_OUTPUT.Enable(...) at the start of that script, the debug doesn't get logged to the associated output file. or am I missing something?

Regards
Paul

2

Hi Paul,

I don't see a way to collect dbms_output after script execution from automation designer. I'll log an enhancement request for it.

-John

1 Like
3

Thanks John.

Regards
Paul