Top "Dbms-output" questions

Oracle - ORA-06502: PL/SQL: numeric or value error (DBMS_OUTPUT)

I implemented a function that returns clob data-type, and I would like to print the result in DBMS Output. Unfortunately, …

oracle plsql oracle11g dbms-output
DBMS_OUTPUT.PUT_LINE: Deciding how many tabs to put according to output length

I have a procedure where a CURSOR c1 is declared. Then I want to output columns in each role c1 …

sql oracle plsql dbms-output
Passing table name and column name dynamically to PL/SQL Stored procedure

I am trying to pass table name and column name to a stored procedure in oracle , but it gives me …

sql oracle plsql execute-immediate dbms-output
Is dbms_output.put() being buffered differently from dbms_output.put_line()?

Im using Aqua Data Studio to debug a stored proc by scattering output statments throughout. I have a delete statement …

oracle plsql oracle10g dbms-output
How to use dbms_output to display an array of values assigned to a variable?

I have something like this, but got an error says ORA-06533: Subscript beyond count. I want to see all the …

arrays oracle variables plsql dbms-output
sqldeveloper - DBMS_OUTPUT.PUT_LINE() Doesn't Work

I am trying to print the value passed to the DBMS_OUTPUT.PUT_LINE() function to the DBMS_OUTPUT screen …

plsql oracle-sqldeveloper dbms-output
Oracle PL/SQL: How to write a loop in order to print all the components of a variable of Oracle customized type?

Please suppose you have an Oracle TYPE so defined: TYPE rec_customized IS RECORD ( SECRET_CODE VARCHAR2 (16), PUBLIC_CODE VARCHAR2 (6), …

oracle types plsql record dbms-output
dbms_output.put_line prints nothing in SQL Developer version 18.1.0.095

My database is: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit The company just gave me a new desktop with …

oracle-sqldeveloper dbms-output
Oracle SQL trigger - DBMS_OUTPUT.PUT_LINE

I'm creating a trigger within my database, I came across two error that I am not able to fix, I'm …

sql oracle plsql triggers dbms-output
Use dbms_output.put_line in Datagrip for .sql files

I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. …

oracle plsql datagrip dbms-output