Stack Overflow
Stack Overflow

Questions tagged [dbms-output]

145 questions
0
votes
1 answer

DBMS_OUTPUT.PUT_LINE not showing message to user

I am trying to create a trigger that would check for a null value in column namesdreservation_status from my table passenger and set it to a default value if it's null and show the user a message of it being set to default. The trigger is created…
Gulsicka
  • 3
  • 2
0
votes
1 answer

PUT_LINE is limited to 100 lines

I cannot output more than 100 lines using dbms_output.put_line in an Oracle PL/SQL anonymous block. Please see the sample code for the two examples: One example that works, one that doesn't work. Thank you. # # ### CODE SAMPLE #1 ### THE…
M. Kemp
  • 107
  • 1
  • 1
  • 6
0
votes
3 answers

Using dbms_output.get_line in VB.NET

I have some stored procedures to execute that use dbms_output.put_line() to put data into the output buffer. I know I need to use dbms_output.get_line(:line, :status) to retrieve that output. I'm using System.Data.OracleClient to avoid headaches…
Riddari
  • 1,713
  • 3
  • 26
  • 57
0
votes
2 answers

Using multiple procedures and multiple cursors in a package

I have created a package with two procedures and two cursors in it, but while executing the procedure, it is executed successful, but same record executed multiple times and a buffer overflow occurred. I also tried removing the loop from the cursor…
user11556276
0
votes
1 answer

DBMS output not displaying

DBMS output not displaying DECLARE COUNT1 NUMBER; BEGIN SELECT COUNT(*) INTO COUNT1 FROM PROCESSPART WHERE DIV = '1' AND BK = '0G' AND BK_YR = '19'; DBMS_OUTPUT.PUT_LINE('PROCESSPART RECORDS IN GEN5 FOR LOC 1, BK 0G,…
J.C.
  • 1
0
votes
2 answers

How to get the output of an unnamed PL/SQL block in Oracle SQL Worksheet online? It's showing Unsupported Command for SET SERVEROUTPUT ON;

I'm trying PL/SQL on online Oracle SQL Worksheet - Live Oracle SQL. I'm unable to display the output of the block, in spite of adding SET SERVEROUTPUT ON; This is my code SET SERVEROUTPUT ON; declare i number:=2; j number:=0; counter…
Vaishnavi Killekar
  • 457
  • 1
  • 8
  • 22
0
votes
1 answer

what is the difference between dbms_output, output variable, output script and output result in oracle

I'm a bit confuse. What is difference between dbms_output, output variable, output script and output result in oracle. Because I want to write a stored procedure in Oracle. Then, the stored procedure will be executed from my typescript codes. But.…
Hanani Rafei
  • 43
  • 1
  • 4
0
votes
1 answer

how to execute immediate sql string to shows result direcly?

I'm trying to execute sql string be executed like this image1 but. when I execute immediate my sql string, it doesn't return to any output like the first one. how can I make it return the output without pass the output into a variable? please help
Hanani Rafei
  • 43
  • 1
  • 4
0
votes
1 answer

PL/SQL looping through PDBs

I am trying to write a PL/SQL script to loop through all of the pluggable databases, perform a task and produce an output. The code below is what I've done so far. I am not sure what is wrong but the error I am getting is PLS-00306: wrong number or…
LNL
  • 5
  • 2
0
votes
1 answer

PL/SQL Procedure Error by dbms output function

I have the following task: "Write a Print Siblings procedure (p person) that has as input the name or ID of the person from the family tree scheme and, as a result, outputs the list of siblings." Table Relations which contains the information of…
Maiwand
  • 127
  • 1
  • 14
0
votes
1 answer

Oracle procedure giving different ASCII outputs

This procedure prints the ASCII code for each character in a string. If executed in TOAD, it prints these ASCII codes: 55 48 48 32 32 32 32 32 32 32 49 which are the right ones. If executed via SQLPLUS on the UNIX server and spool the output of the…
Rick
  • 55
  • 1
  • 12
0
votes
0 answers

Oracle database loading data from text file to database using UTL_file and dbms

I am trying to upload data from text file to my table using UTL_FILE from SQL PLUS. the text file name testb.txt contain data: 10,mike 20,bill 30,kim and in my the table in the database called mytable contain columns (empno, empname) I tried this…
C.Z
  • 1
  • 1
  • 3
0
votes
2 answers

How to get the dbms_output.put_line within the store procedure result by unix korn shell

Please refer to my sample, In oracle DB,these is below SP CREATE OR REPLACE PROCEDURE SP_TEST_PUTLINE AS BEGIN DBMS_OUTPUT.ENABLE; dbms_output.put_line('Hello world!'); END SP_TEST_PUTLINE; I use the unix shell to call SP to get the…
Tom
  • 121
  • 2
  • 14
0
votes
0 answers

dbms_output.put_line appears in SQL Developer and in SQL Plus differently (not-execute and execute)

there is any 'execute settings' option in SQL developer? I created a trigger with dbms_output.put_line (and 'set serveroutput on' as well) - and I experienced that SQL developer and SQLPlus worked differently: the SQL developer: shows the…
diaphol
  • 117
  • 1
  • 9
0
votes
1 answer

Procedure fails with numeric or value error

I'm working on a procedure to take rows from a table and change the names slightly to make 50 rows total... as you'll see in code. However, I'm having an issue a numeric or value error, as you'll see in code I try using …
Cyrus
  • 57
  • 7
1 2 3
…
9 10