I have a bunch of scripts running through VC that basically run a block of PL/SQL code against on Oracle database. The code runs perfectly, but I'm having trouble figuring out how to pull any messages it produces back to VC. Ideally, what I'd like to do is something like this:
DBMS_OUTPUT.PUT_LINE('This is some output');
And have the Output variable of the SQL task contain "This is some output". That doesn't seem to work though, so I'm wondering if there is a way to do this that I'm not aware of. The only way I've been able to do it is to have my PL/SQL code write the messages to a table within the Oracle database, and later on in the VC job, have a separate SQL task that queries for those messages. I'd prefer not to do it that way though, because it assumes that I actually have a table available to me where I can write these messages to. For some applications, I do, but for others I don't.
Edited by moderator
| Reason: Not specified