Menu
I try to write a MySQL strored procedure, and want to send some output to console, or stdout. Oracle use DBMS_OUTPUT.PUTLINE to debugginf.
Is there an equivalent of DBMS_OUTPUT in MySQL stored procedures?
585
The Oracle dbms_output. put_line procedure allows you to write data to flat file or to direct your PL/SQL output to a screen. Here is a code example using dbms_output.
43. DBMS_OUTPUT. The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers. The PUT and PUT_LINE procedures in this package enable you to place information in a buffer that can be read by another trigger, procedure, or package.
The DBMS_OUTPUT is a built-in package that enables you to display output, debugging information, and send messages from PL/SQL blocks, subprograms, packages, and triggers.
So yes, dbms_output. put_line decreases the performance.
In Oracle :
DBMS_OUTPUT.put('Hello World');
In MySQL :
SELECT 'Hello World!';
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
