No, none that I am aware of, but I haven't used Oracle in a while, and I dont have an Oracle installation handy to try it out.
However, if you can capture the output of dbms_output using JDBC, there should be a way of doing something similar using this too.
One way (and this is not currently supported) would be to configure dbms_output to send the results to a file and have a test type where the contents of the file are matched with a specified expected string.
If you are unable to figure out how to get the dbms_output using JDBC, then this is probably a good feature request to put in for the next version.
-sujit
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is there a way to check the output msg done by dbms_output.put_line('bababa')?
Thanks,
jini
Hi jiniduck,
No, none that I am aware of, but I haven't used Oracle in a while, and I dont have an Oracle installation handy to try it out.
However, if you can capture the output of dbms_output using JDBC, there should be a way of doing something similar using this too.
One way (and this is not currently supported) would be to configure dbms_output to send the results to a file and have a test type where the contents of the file are matched with a specified expected string.
If you are unable to figure out how to get the dbms_output using JDBC, then this is probably a good feature request to put in for the next version.
-sujit