VBA and Oracle Stored Procedure dbms.put_line capture task:
I have stored procedures that I can call using a vba module.
I can append the parameters and it all works quite nicely.
The stored procedures are used in other places as well,so I don't want to change
if I don't absolutely have to.
The Oracle proc has informational output displays dbms.put_line "stuff"
that I would like to capture in my vba function.
I know how to execute the stored_procedure and retrieve the cursor if I want too.
How do I capture the oracle output at the end?
(btw: This particular procedure does not return a cursor or result set.)
Since I can test the err.description and get the Oracle Error Message, I'm
guessing, that I can get the dbms.put_line output too?
Can I capture it without changeing the Oracle side of things?
If so, can some provide a sample please?
thank you, bangel