Stack Overflow
Stack Overflow

Questions tagged [dbms-output]

145 questions
0
votes
1 answer

Using jMeter to read values from DBMS_OUTPUT.PUT_LINE

what would be the easiest/most efficient way to read the values, that have been put in the buffer already? I have something like this: Dbms_Output.Put_Line('a -> 3'); Dbms_Output.Put_Line(a); And I want to know if I can put anything in my JDBC…
haumaru
  • 51
  • 4
0
votes
1 answer

I am going over the ne04j movie tutorial database and I want to output movie has the most number of actors in it?

Which movie has the most number of actors in it? Which pair of actors have acted together in most number of movies? Here's what i tried MATCH (actor:Person)-[:ACTED_IN]-(movie:Movie) RETURN movie.name I expect the movie name with a count of the…
user15428511
  • 1
0
votes
1 answer

Why Oracle weblogic server logs does not show DBMS_OUTPUT.PUT_LINE outputs?

I have included some DBMS_OUTPUT.PUT_LINE inside my PLSQL package procedure. I wanted print these output in weblogic application server logs. But it does not show my DBMS_OUTPUT in weblogic server log. Currently, I use Log4j for server logging. Is…
user4935529
  • 1
  • 1
0
votes
2 answers

Output cursor data with dbms_output.put_line

--pkg create or replace package cur_pkg as type t_cur is ref cursor; procedure open_cur_spr_ppl (spr_id in number, spr_name in varchar2, spr_family in varchar2); end cur_pkg; --pkg_body create or replace package body cur_pkg as procedure…
DZD00
  • 1
0
votes
0 answers

Oracle PL/SQL dbms_output to Jenkins console

Using Cloudbees SDA CI to implement Jenkins, with Oracle 19 P/SQL running in many jobs. Using dbms_output in the Oracle script, the output does not show up in the Jenkins console at all. I'm looking for functionality that would allow me to print to…
Pat Jones
  • 876
  • 8
  • 18
0
votes
1 answer

How do I get dbms_output to show when running a script in command window in PL/SQL Developer?

This is a follow up question to this I am trying to run the following script in PL/SQL Developer in a Command Window: DECLARE ncount NUMBER; vwhere VARCHAR2(1000) := ''; vselect VARCHAR2(1000) := ' select count(1) from '; vsearchstr…
gib65
  • 1,709
  • 3
  • 24
  • 58
0
votes
1 answer

Why do I get no output from this query (searching database for string)?

I'm an Oracle/PL/SQL Developer newbie, and I'm struggling to figure out how to see the output of this query: DECLARE ncount NUMBER; vwhere VARCHAR2(1000) := ''; vselect VARCHAR2(1000) := ' select count(1) from '; vsearchstr VARCHAR2(1000) :=…
gib65
  • 1,709
  • 3
  • 24
  • 58
0
votes
1 answer

Dynamically building DBMS_CLOUD.CREATE_EXTERNAL_TABLE, Execute Immediate doesn't work

I'm facing an issue when I'm trying to build a table dynamically using DBMS_CLOUD.CREATE_EXTERNAL_TABLE inside a stored procedure or packaged program. A dbms_ouput.put_line of the dynamic code will produce the correct code which i can copy and run…
B-Rad
  • 25
  • 6
0
votes
1 answer

dba_scheduler_job_run_details and dbms_output

dba_scheduler_job_run_details is capable to keep an dbms_output.put_line lines in dba_scheduler_job_run_details.output column. And it is so, when the job flows and exits normally. However, when I explicitly call dbms_scheduler.stop_job - all the…
Andrew Klimov
  • 126
  • 8
0
votes
1 answer

How can I run functions of dbms_output as non-admin?

I have XE on my computer, using Oracle Database 18c. Earlier, I was able to execute function dbms_output.put_line(); even I logged in as sysadmin or with default role. Now, I only can run dbms_output.put_line() when I am logged in as…
Blockedbycodes
  • 11
  • 4
0
votes
1 answer

Change the value of a column in previous row and the current row whenever a new row is inserted in PLSQL

lets say the table name is abc and **columns are name varchar(20) and status varchar(1),**status can be either 'y' or 'n' on insertion of each new row the status value of the new row must be set to 'y' and the status value of previous row has to be…
lakshmi chandhana
  • 1
  • 1
0
votes
1 answer

Capture SQL/Developer Script Output in PL/SQL

In SQL/Developer, when I execute a statement I get a Script Output message that reads something like 7 Records Merged Here's my relevant PL/SQL Code: v_sql_loader := 'merge into foobar b using foobiz i on (b.foobar_id = i.foobiz_id) when not…
zundarz
  • 1,540
  • 3
  • 24
  • 40
0
votes
1 answer

DBMS_Output: Some extra "enable" might be missing

Sorry the silly question. I am stuck with Dbms_Output: First I tried it within a batch/sqlplus call. But the spool file would only contain the message "pl/sql sucessfully executed". (See first code part) I am running the code on Oracle Database…
Peter Frey
  • 361
  • 4
  • 17
0
votes
1 answer

SQL dbms_output.put_line formatting

I would like it to be like when you do a select query from a table(like columns). I added tab characters for the column names but doing so between the names and statuses, offsets some of the demand statuses because the name is too long. When dbms…
Brandon Myler
  • 23
  • 4
0
votes
2 answers

Unable to see DBMS_OUTPUT in Oracle SQL Developer

I am using Oracle Sql Developer (Version 18.4.0.376).In Sql editor all DBMS_OUTPUT.PUT_LINE are not disabled automatically. Please refer the below screen shots Can any one suggest me, How to get ride this issue.
Lova Chittumuri
  • 2,994
  • 1
  • 30
  • 33
1 2 3
…
9 10