When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it to (firstName, lastName) and then the other values from the select query in a t...

I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. Before this I was using Oracle SQL developer and I was able to use DBMS_OUTPUT by adding the fol...

Does dbms_output.put_line decrease the performance in plsql code?

I have an SQL script that is called from within a shell script and takes a long time to run. It currently contains dbms_output.put_line statements at various points. The output from these print sta...

I am learning cursors and I cannot print the boolean value in the dbms_output.put_line(); The code is DECLARE CURSOR c_employees_3i is SELECT * FROM employees_3i; row_count BOOLEAN; BEGIN OPEN...

I need to debug in pl/sql to figure times of procedures, I want to use: SELECT systimestamp FROM dual INTO time_db; DBMS_OUTPUT.PUT_LINE('time before procedure ' || time_db); but I don't underst...

I have three tables with following data Table 3 : Table1_id Table2_id 1 1 1 2 1 3 2 1 2 3 3 2 Table 2 : Table2_id Name 1 A 2 B 3 C Table 1 : Table1_id Name 1 P 2 Q 3 R I have a problem w...

When executing the following code, it just says the procedure is completed and doesn't print the infomation . BEGIN dbms_output.put_line('This is my first program'); END; / When I execut...

I implemented a function that returns clob data-type, and I would like to print the result in DBMS Output. Unfortunately, I am getting ORA-06502: PL/SQL: numeric or value error and I think it is du...

I tried to debug my dynamic query via dbms_output but seems like the query string is too long for dbms_output buffer. I got : ORA-06502: PL/SQL: numeric or value error: character string buffer t...

I tried to set the dbms_output size to unlimited inside a stored procedure. But it gave me compilation errors. So I tried in the SQL*Plus prompt the below way. But still I get the buffer overflow ...

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 stor...

I am using SQL Developer and want to output the contents of a variable to the console using DBMS_OUTPUT.PUT_LINE(). I am running the following code that adds the numbers 1 through 5 inclusive...

I have a fairly time intensive PL/SQL block that builds fingerprints from molecular structures. I would like to print output to SQL*Plus console to provide feedback on how many structures have been...

Simple question, is it possible to give an alias to the output function in the question title so that I can call something like trace('hello') rather than DBMS_OUTPUT.PUT_LINE('hello')? I would li...

especially one that doesn't have the 256 max chars/line and 1000000 max chars/buffer limitation.