Questions tagged [dbms-output]
145 questions
0
votes
1 answer
Error when retriveing output from dbms_metadata.get_ddl
When I have tried to run the following SQL statements I'm getting the error:
set long 90000
set heading 999
set lines 100
select
dbms_metadata.GET_DDL(u.object_type,u.object_name,'MY_SCHEMA')
from
dba_objects u
where
owner =…
SocketM
- 564
- 1
- 19
- 34
0
votes
0 answers
Toad dbms_output does not show result correctly
I have problem with dbms_output in Toad, it ignores spaces, and lpad and rpad functions.
When I execute this procedure:
create or replace procedure example
as
w clob;
l_line varchar2 (244):=' ';
l_line_2 varchar2 (244):=' ';
begin
…
Tom
- 43
- 9
0
votes
3 answers
I want to transform my Table from first displayed form to second displayed form
My query is :
SELECT
ROUND(AVG([Q]), 1) AS ABC,
(SELECT ROUND(AVG([Q]), 1)
FROM [Apple]
WHERE [Name] = 'DND' AND [Color] = 'Blue') AS 'Internal',
(SELECT ROUND(AVG([Q]), 1)
FROM [Apple]
WHERE [Name] = 'DND' AND…
Bhargav
- 3
- 1
- 5
0
votes
0 answers
Is there a way to intercept database output (dbms_output) with sql2o?
I am using sql2o with Oracle database in a Java-based project. Often in my sql queries I use dbms_output.Put_line('A message...') in order to track what is going on.
Is there a way to intercept this output with sql2o so I can pass it on to my logs?…
JDelorean
- 631
- 13
- 26
0
votes
1 answer
Oracle PL/SQL - how can I format the data displayed on screen?
I've written a stored procedure to display on screen details about employees salary and it works great, but I would like to fix the information displayed on screen. I tried to use LPAD and RPAD function to order "columns" on screen but it doesn't…
Young Al Capone
- 369
- 1
- 6
- 25
0
votes
3 answers
Oracle DBMS_OUTPUT of V$RESOURCE_LIMIT
I am trying to get the Oracle DBMS_OUTPUT of V$RESOURCE_LIMIT results via a procedure.
However, I am getting the error about c1 not being complete or malformed.
So far, I have the following code:
CREATE OR REPLACE PROCEDURE resource_output…
Annon
- 85
- 1
- 1
- 8
0
votes
0 answers
Oracle VARCHAR Parameter always returns "1" from PL/SQL Stored Procedure in C#
I am trying to get a string from a stored procedure in C# .NET from Oracle PL/SQL. The query is OK in Oracle SQL Developer, but the output parameter in C# will always return "1". I have tried setting different parameter size, direction, etc. Nothing…
Dionis
- 73
- 7
0
votes
1 answer
How to get DBMS_ADDM report output through PHP
I am trying to get the ADDM report for Oracle Database. The output is in an array fashion as a .txt. I need to display it in a table row format. I'm not getting the desired output however.
$today = date("His");
$taskname =$username.$today;
…
OrangeLime
- 105
- 3
- 10
0
votes
1 answer
How to find a dbms_output.put_line() alternative to print contents line by line every time when it gets called in every iteration?
I want to view the output as the program goes while processing some records. Reading the line will not help, as it just retrieves is from the buffer and nothing else. For example:
DECLARE
CURSOR cEmploee IS SELECT * FROM g_emploees;
iTotal…
Деян Добромиров
- 833
- 1
- 10
- 22
0
votes
0 answers
Dbms_Output.Put_Line not printing inside inner functions/procedures
I am running a PL/SQL anonymous block on SQL developer that calls some functions /procedures (which in turn call other functions/procedures) .... the outer block contains some Dbms_Output.Put_Line statements as well as the called…
osama yaccoub
- 1,884
- 2
- 17
- 47
0
votes
0 answers
coldfusion query table of co ordinates to find locations within radius
I have the following sql code that works within sql however i am wanting to be able to perform the query via cfml template passing to it the radius and the long / lat of current location which needs to be converted into a geography type first…
user3939487
0
votes
1 answer
While loops checking with time
Just wondering if you could help me with a question.
I have been told to write a function or anonymous block that will run until you put an item in a table/
The programme should check every 5 seconds for an entry. It should output a message…
Arianna.Ellen
- 47
- 3
0
votes
1 answer
Looping statement
I am working on a loop to bring back the times tables from 1-12. I have completed this by using the following:
BEGIN
FOR i IN 1..12
LOOP
FOR j IN (i)..12
LOOP
dbms_output.put_line ( (i ) || '*' || (j ) || ('=') || (i*j) );
END LOOP;
END…
Arianna.Ellen
- 47
- 3
0
votes
1 answer
Minimum number of tables for ER diagram
I came across to an ER diagram
Department(Dno,Dname,Phone,address)
where phone and address are multivalued attributes.
What is the minimum number of tables formed? Will it be 2 or 3?
According to me it should be 3 but answer is 2.
Can anyone…
user3564975
- 21
- 1
- 4
0
votes
1 answer
DBMS_OUTPUT in Toad on Eclipse
I am writing a PL/SQL stored procedure using Toad in Eclipse. I have it working just fine and the procedure is below:
CREATE OR REPLACE PROCEDURE crl_sync
IS
unit_separator CONSTANT char:= CHR(31);
record_separator CONSTANT char:=…
Neil Benn
- 904
- 1
- 12
- 31