python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - command-window

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) :...
test-img

gib65

plsqldeveloper

dbms-output

command-window

Votes: 0

Answers: 1

Latest Answer

It turns out the problem wasn't with dbms_output, but two things: 1) dbms_output.get_line(vline, istatus) was clearing the output buffer, and 2) there were only a limit set of table the FOR loop was s...
test-img

gib65

How do I set the default directory that the PL/SQL Developer Command Window opens in?

I'm trying to run a script in a sql file in PL/SQL Developer. I open a command window and I find myself not in the directory where the sql script is. I encounter a couple issues when trying to naviga...
test-img

gib65

oracle

directory

configuration

plsqldeveloper

command-window

Votes: 0

Answers: 1

Latest Answer

To change the default directory for the PL/SQL Developer Command Window, go to Configure-->Preferences-->Files-->Directories and set the "Command files" directory: Although in gene...
test-img

Jon Heller

Posts

Questions

Blogs

Jobs