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!

Answer 1

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:

• Difference Between SQL and PLSQL
• Using JDBC Sampler in JMeter
• Samples of PL/SQL in JDBC