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 =>…
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…
1 2 3
9
10