PL/SQL Developer Command Window executes host command asynchronously (unwanted)

(PL/SQL Developer 9.0.6 & Oracle Server 11.2.0.3)

From a Command Window when using host command to shell out and execute something, the script does not wait for the return of the shell as it would if I were using SQL*Plus.

create table mytable (
...
;
host impdp /@mydb SCHEMAS=myschema NETWORK_LINK=mydblink CONTENT=data_only
create table mytable2 (
...
;

I want the data pump import to finish before before proceeding to execute creating mytable2.

My current hack is to put a dummy accept after the host command to pause the script. I want to eliminate the unnecessary hack.

Is there a setting in PL/SQL Developer to make the Command Window behavior consistent with SQL*Plus in this regard?

Answers


No, this feature does not exist. See this thread on the Allround Automations forum where someone else had the same problem. The response was "We'll try to enhance this."

You may want to reply to that thread, so they know that the feature would help more than one person. Not every feature request gets implemented, but the company does appear to pay attention to anything posted on their forums.


Need Your Help

C++ memory management paradigms

c++ c++11 memory-management stl

I'm moving from C to C++11 and trying to figure out the memory management paradigm for C++11 programs (or any modern languages with built-in exceptions). Specifically, I'm having a crack at game

Add a trusted domain to everyone in exchange

powershell exchange-server exchange-server-2010

Currently we have an HR email going out to the all of our staff. By default, the email gets sorted into the junk email for everyone.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.