Questions tagged [dbms-output]
145 questions
0
votes
1 answer
Oracle 11G repeats output_put.put_line twice. How to solve this?
My loop is given me twice the results. As I only want it one time. What should I do?
for i in 1..length(newStudentNumber) loop
character := SUBSTR(newStudentNumber, i, 1);
newStudentNumber := newStudentNumber || case character
when 'A'…

Maxime de Lange
- 287
- 2
- 7
- 21
0
votes
1 answer
Can I run a script in Excel that returns dbms_output instead of a query
I have a stored procedure that returns formatted, delimited text using dbms_output.put_line statements. Currently, we run the script in Toad and manually paste the output into Excel, but I was hoping I could cut out a step and get the output…

SarekOfVulcan
- 1,348
- 4
- 16
- 35
0
votes
1 answer
PLSQL nested loop to output data
I am trying to find a code that creates a box such as...
XXX
XXX
XXX
(exp. 3x3) depending on what the user inputs as row and height variables. My nested loop is not working correctly. Can I please get some help?
Heres code...
Set ServerOutput…

Luke
- 31
- 8
0
votes
1 answer
IBM DB2 DBMS_OUTPUT in Functions
I'd like to know if is possible use de DBMS_OUTPUT module of DB2 in a function and how can I use this when I'm running the select.
It's possible use something like:
SET SERVEROUTPUT ON
SELECT MYFUNCTION FROM TABLE;
Thanks

mayconbelfort
- 195
- 1
- 5
- 17
0
votes
3 answers
DMBS_OUTPUT --> DMBS_SCHEDULER
I use a DBMS_OUTPUT.PUT_LINE('TEST') in a procedure to check every call of these procedure. The procedure is called by DBMS_SCHEDULER. job --> schedule every minute.
But there is no output on my DBMS_OUTPUT in my Developer.
Log-Table listed perferct…

michael-mammut
- 2,595
- 5
- 28
- 46
0
votes
2 answers
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 values from the "select distinct" statement in the output tab. Anyone can help? thanks!
DECLARE
TYPE v_chks_array IS VARRAY (10) OF…

gcbm1984
- 53
- 1
- 4
- 9
0
votes
1 answer
run plsql and get DBMS_OUTPUT.PUT_LINE (yii)
i am developing a web app with oracle database and yii framework
$connection = Yii::app()->oo;
$command = $connection->createCommand("DECLARE V_COD NUMBER; v_Return DATA.FIND.T_REG;
BEGIN
V_COD := 1529;
v_Return := FIND.DATA(
V_COD =>…

torresfcamilo
- 52
- 7
0
votes
1 answer
Change in between the dbms_output procedure?
i had a problem when i am using dbms_output package. When i am executing the following code it display integer is 0
declare
v integer;
asq…

Smart003
- 1,119
- 2
- 16
- 31
0
votes
1 answer
Write Output of DBMS.OUTPUT.put_line To Specified Common Location Like Desktop
I have a long series of calls like:
DBMS_OUTPUT.put_line(v_1||','||v_2);
I have only read priveleges to the database and invision writing the ouptut from the statement above to a common location on all computers that I might read from later (using…

ZAX
- 968
- 3
- 21
- 49
0
votes
0 answers
Equivalent to dbms_output in Soapui JDBC step?
I got a question nobody seems to care about because I have not found anything on the the web.
I am using the free version of SOAPUI. I use some JDBC steps (Oracle driver) in my testCases.
In my SQL code, it would be very usefull for me to output…

M'sieur Toph'
- 2,534
- 1
- 21
- 34
0
votes
1 answer
How to check DBMS_OUTPUT size in my oracle DB
Im facing below exception in Oracle DB.
java.lang.RuntimeException: java.lang.RuntimeException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [call SRS_ADMIN.SLI_UTIL.copyData(?,?)]; nested exception is…

Srinivasan
- 11,718
- 30
- 64
- 92
0
votes
1 answer
oracle dbms_output to a literal control Asp.net
In Oracle, can I write dbms_output to a literal control or label control in Asp.net? I need to create a report which would render in a literal control.

Nisar
- 5,708
- 17
- 68
- 83
0
votes
1 answer
Detecting last line with dbms_output.put_line
I'm curious on how to code this process. I am using collection objects to pull information from a table. Then I am using dbms_output.put_line to display the values that I collected.
I want to append a line to the last line of my output. For…
-1
votes
2 answers
How to print detail of all employee '%rowtype' in oracle dbms using pl/sql cursor?
here is my code,
declare
cursor c_emp is
select ename, sal, mgr from emp;
emp_detail emp%rowtype;
begin
open c_emp;
loop
fetch c_emp into emp_detail;
exit when c_emp%NOTFOUND;
…

Prince Raj
- 52
- 7
-1
votes
1 answer
My Oracle SQL Code is compiling my block of code that uses a cursor for a loop from two tables but the dbms output line is not showing the results
I am trying to write a block of SQL code that compares two dates from two tables. One table shows when an item was acquired (ci_acquired_date). Another table shows when an item was an assigned to an employee (date_acquired). My goal is to use a loop…

kielp2
- 11
- 3