Using jMeter to read values from DBMS_OUTPUT.PUT_LINE

Question

what would be the easiest/most efficient way to read the values, that have been put in the buffer already?

I have something like this:

Dbms_Output.Put_Line('a -> 3');
Dbms_Output.Put_Line(a);

And I want to know if I can put anything in my JDBC Sampler, which can read the value of "a" and return it as a response, so I can use it as a parameter in my next request?

I was thinking about Dbms_Output.Get_Line(s), but not sure what should be the syntax and if this will solve my issue.

Thanks in advance!

The primary purpose of `DBMS_OUTPUT` is for debugging. It's is not intended to be used to return data. — pmdba, Jan 04 '23 at 11:57

score 0 · Answer 1 · answered Jan 04 '23 at 09:31

No, you can execute SQL statements like select or update and call stored procedures and only one statement at a time.

Theoretically you can create a stored procedure like it's described in How to Fetch Oracle DBMS_OUTPUT from JDBC article but I'm not sure whether it's something you're looking for

More information:

Using jMeter to read values from DBMS_OUTPUT.PUT_LINE

1 Answers1