Stack Overflow
Stack Overflow

Questions tagged [dbms-output]

145 questions
1
vote
3 answers

How to clear DBMS_OUTPUT with a command

I tried with: clear screen (not work)
user3402040
1
vote
0 answers

DBMS_OUTPUT not working within procedure in SQL Developer

I am using Oracle and SQL Developer and I tried to code the function below. All is working fine, except for DBMS_OUTPUT.PUT_LINE. My console for output was activated in SQL Developer. My query was OK, all field are OK. Did the DBMS_OUTPUT.PUT_LINE…
SurveyVisual
  • 27
  • 1
  • 8
1
vote
1 answer

PL/SQL - DBMS_OUTPUT is wrapping text

Since our company upgraded our version of Oracle SQL Developer, I've been noticing issues when outputting data to the DBMS_OUTPUT using DBMS_OUTPUT.PUT_LINE. We use this function and combine it with the text-to-columns feature in Excel to quickly…
TomB
  • 255
  • 2
  • 5
  • 15
1
vote
2 answers

Replacing DBMS_OUPUT in a PL/SQL test LOOP to return a collection

So I have this assignment where I have to create a stored procedure to search for movies in an Oracle DataBase. The search string follow the following logic : It looks for the year of the movie in parenthesis Ex. (1992) It looks for a range of…
user3220633
  • 414
  • 4
  • 13
1
vote
3 answers

Average number of queries for best performance

I hope you guys wont mind my asking an off-topic and naive question. But, I could not find any satisfying answer for this. Maximum, how many queries on an average a page must be allowed to process for rendering output(I am looking for the quality…
Penguine
  • 519
  • 6
  • 19
1
vote
1 answer

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 following error: table or view does not exist Below is the code: create or replace procedure jz_dynamic_sql_statement (p_table_name in…
akaminko
  • 71
  • 1
  • 2
  • 11
1
vote
2 answers

DBMS OUTPUT PUT doesn't print anything

I'm new to PL/SQL and I want to show the following message. When I compile it in SQL Developer I only get PL/SQL procedure successfully completed. My code is this: SET SERVEROUTPUT ON; DECLARE mesaj VARCHAR2 (100) := 'PL/SQL'; BEGIN …
Stefan
  • 83
  • 1
  • 6
  • 20
1
vote
1 answer

How do I retrieve Oracle DBMS_Output from a vb.net application

I'm working on a vb.net application that executes an Oracle stored procedure. The stored procedure displays a value using dbms_output.put_line. How do I retrieve that value from the oracle database into my vb.net code?
Keith
  • 11
  • 2
1
vote
1 answer

dbms_output with dbms_lob.substr

According to this answer I can loop a clob and print it using substr: DECLARE v_clob CLOB; v_offset NUMBER DEFAULT 1; v_chunk_size NUMBER := 10000; BEGIN FOR I IN 1 .. 500 LOOP v_clob := v_clob || chr(10) || 'select…
diegon
  • 11
  • 2
1
vote
1 answer

Receiving error during compile test of procedure

I've written a short procedure when a donor id is input it checks for active pledge based on status field (NUMBER for data type 10 is active, 20 is complete) and is making monthly payments and return boolean value True if all conditions are met and…
allendks45
  • 339
  • 5
  • 18
1
vote
2 answers

Line break in dbms_output.put_line

I run some Oracle procedure with the help of cursor and get output in logfile via dbms_output.put_line. What I would like to do is break line on server_name, is it possible with dbms_output.put_line? currently it list everything together which…
homer
  • 423
  • 2
  • 11
  • 24
1
vote
0 answers

How DBMS_OUTPUT works internally

Recently, one of our DBAs suggested me removing DBMS_OUTPUT.PUT_LINE() in one of my package at least have a compilation flag to control it. The strongest argument is the buffer limitation will cause exceptions in DB. Although I fully agree we…
ivenxu
  • 639
  • 4
  • 16
1
vote
1 answer

PL/SQL, Cannot print variable

I'm trying to learn PL/SQL by simply assigning a variable from a select statement and then, to confirm it's working, print it sql output. DECLARE ALLOW_STUFF NUMBER; BEGIN SELECT VAL_N INTO ALLOW_STUFF FROM MY_TABLE WHERE MY_KEY = 'ALLOW_ME'; …
Lurk21
  • 2,307
  • 12
  • 37
  • 55
1
vote
4 answers

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 fetches. FOR rec IN c1 LOOP DBMS_OUTPUT.PUT_LINE (rec.branchno || CHR(9) || rec.street || CHR(9) || rec.city || CHR(9) ||…
goldfrapp04
  • 2,326
  • 7
  • 34
  • 46
1
vote
1 answer

Showing Trigger DBMS_OUTPUT.PUT_LINE in Oracle Apex

I have a trigger: CREATE OR REPLACE TRIGGER Med_Allergy_Warning BEFORE INSERT ON Prescription FOR EACH ROW BEGIN IF (Find_ADR(:NEW.Visit_ID, :NEW.Medication_ID) != 'GOOOO') THEN DBMS_OUTPUT.PUT_LINE('Medication ('||:NEW.Medication_ID||')…
user1869735
1 2 3
…
9 10