• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1289
  • Last Modified:

VBA and Oracle Stored Procedure dbms.put_line capture task:

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.

My Question:

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
  • 2
3 Solutions
Your question is not posted in Oracle Zone!
"dbms_output.put_line" can be retrieved by using dbms_output.get_line
An excellent example in Java is given by Tom Kyte in

Convert it to your script.
bangelAuthor Commented:
thank you I read Tom's article, and get back to ya
bangelAuthor Commented:
I have read the article, and it looks like I can rewrite in vb.  Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now