Questions tagged [dbms-output]
145 questions
2
votes
1 answer
adding a space after each 4th number/digit Oracle 11G
I am trying to get a space into every 4th number/digit (not character). This is what I come up with:
newStudentNumber := regexp_replace(newStudentNumber, '[[:digit:]](....)', '\1 ');
dbms_output.put_line(newStudentNumber);
result:
NL 2345 7894 …
Maxime de Lange
- 287
- 2
- 7
- 21
2
votes
2 answers
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 pretty sure that those two are relating to my use of DBMS_OUTPUT.PUT_LINE, the rest of the statement does not cause any errors, although it had before.…
Joe Doe
- 193
- 1
- 5
- 13
2
votes
2 answers
DBMS OUTPUT doesn't work
I need a piece of advice there. I'm using Oracle Developer for a few anonymous PL/SQL blocks. The problem is that when I run it, the dbms_output don't give me anything even though the script is correct (anonymous block completed).
What is wrong?…
redhat01
- 135
- 4
- 14
2
votes
1 answer
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),
COMMON VARCHAR2 (40),
EMAIL …
UltraCommit
- 2,236
- 7
- 43
- 61
2
votes
2 answers
Oracle SQL script to build SQL script using dbms_output
This may be a stupid idea. I am trying to write a SQL*Plus .sql script that I can call from a Windows batch file that itself generates a new .sql script using dbms_output.put_line. This is what I have so far for my script:
set echo off;
set…
Tom
- 81
- 2
- 8
2
votes
1 answer
Oracle dotnet DBMS output query
I am running some code in .net, using the oracleclient in ,net. The SQL code can output a number of responses using the DBMS_PUT_LINE function, which I then retrieve with a call to DBMS_GET_LINE. If the output is just a specific line of text, ie…
Kevin Appleyard
- 149
- 2
- 8
1
vote
2 answers
How to get the dbms.output value returned by a PL-SQL block in C#
I am trying to execute a PL-SQL block in c# using System.Data.OrcaleClient.
The PL-SQL block when executed in oracle, prints the result using dbms.ouput.
I want to get that "dbms.ouput" result in my C# code.
Please help.
Dinu
- 13
- 2
- 6
1
vote
1 answer
How can I reformat already acquired psql query output?
I have default psql query output in .txt file, which is very difficult to read. Any command or service to change it into a more convenient format to work with (e.g. CSV)?
Went through docs, but didn't find the solution. By any chance, can I somehow…
Damir Yablonskikh
- 37
- 4
1
vote
0 answers
SQL*Plus TRIMOUT OFF Prevents Display Output
In SQL*Plus, when I set trimout off the display output disappears. This is unexpected.
Below is an example script that calls dbms_output.put_line once with trimout on and once with trimout off.
set serveroutput on size unlimited format wrapped
set…
Alex Bartsmon
- 471
- 4
- 9
1
vote
2 answers
SQL Query to get multiple resultant on single column
I have a table that looks something like this:
id name status
2 a 1
2 a 2
2 a 3
2 a 2
2 a 1
3 b 2
3 b 1
3 b 2
3 b 1
and the resultant i want is:
id name total count count(status3) count(status2) …
Milind Sahu
- 29
- 4
1
vote
1 answer
How can I see output of dbms_output.put_line() in SQL window in PL/SQL Developer?
I'm not able to see the messages added to dbms_output.put_line() in PL/SQL Developer. Every google hit I see says to use set serveroutput on but this isn't working.
I try to run this script in a SQL Window:
set serveroutput on;
BEGIN
…
gib65
- 1,709
- 3
- 24
- 58
1
vote
2 answers
Loop in SQL oracle, show DBMS_OUTPUT.PUT_LINE before completing the execution
I have a for loop in a dynamic oracle sql statement:
begin
for i in (select x from index_list) loop
-- do stuff with i.x
dmbs_output.put_line('I completed item '||i.x||' of the loop');
end loop;
end;
/
However the messages in…
Giuseppe
- 518
- 10
- 22
1
vote
1 answer
Extensive Data Dictionary and ER Diagram
This is a question for an assignment. Can somebody please help me?
Criteria
Extensive data dictionary that contains appropriate data items and all relevant details of each data item.
Extensive ER diagram that contains appropriate tables and…
Jibin John
- 179
- 1
- 7
1
vote
1 answer
How to access the dbms_output buffer from C code?
Various Oracle solutions involve PL/SQL snippets with the dbms_output package -- in particular the dbms_output.put_line().
These work with the sqlplus interpreter, but some of our code uses the C API (oci.h, ociapr.h and friends).
Is there a way to…
Mikhail T.
- 3,043
- 3
- 29
- 46
1
vote
1 answer
DBMS_OUTPUT buffer size (client or database side)
I use SQL Developer to run queries on Oracle databases, the DBMS_OUTPUT buffer size is set by default (20000) in SQL Developer.
When I run the query against DEV database, everything is OK.
When I run the same query against Production database, the…
Morad
- 11
- 2