Print Thread
wish: open package from database by command line
#14764 08/04/04 06:29 PM
Joined: Aug 2003
Posts: 19
Moscow, Russia
N
Nashev Offline OP
Member
OP Offline
Member
N
Joined: Aug 2003
Posts: 19
Moscow, Russia
I need to open package spec & body in PL/SQL Developer by package name from myself program.

How can i do it in v5.1.6 ?

if it's not possible, add this wish to wish list? please.

Re: wish: open package from database by command line
#14765 08/04/04 09:40 PM
Joined: Aug 1999
Posts: 22,226
Member
Offline
Member
Joined: Aug 1999
Posts: 22,226
In the Command Window you can simply type:

SQL> edit <packagename>

I'm not sure if this is what you mean though.


Marco Kalter
Allround Automations
Re: wish: open package from database by command line
Marco Kalter #40052 05/06/11 02:49 PM
Joined: Aug 2003
Posts: 19
Moscow, Russia
N
Nashev Offline OP
Member
OP Offline
Member
N
Joined: Aug 2003
Posts: 19
Moscow, Russia
Now there are command line parameter "editobject" for this purpose.

But one more question: if I call ShellExecute from my programm with this parameter, Windows will open a new instance of the PL/SQL Developer and my object will be opened there.

Is it possible to open from external application a my database object in the already logged-in instance of PL/SQL Developer? Can You provide some of single-instance-per-login mode for PL/SQL Developer by some kind of interprocess communication between new instance and already executing instances?

Re: wish: open package from database by command line
Nashev #40063 05/09/11 10:26 AM
Joined: Aug 1999
Posts: 22,226
Member
Offline
Member
Joined: Aug 1999
Posts: 22,226
Aren't there standard DDE messages to open a file?


Marco Kalter
Allround Automations
Re: wish: open package from database by command line
Marco Kalter #40291 05/12/11 05:44 PM
Joined: Aug 2003
Posts: 19
Moscow, Russia
N
Nashev Offline OP
Member
OP Offline
Member
N
Joined: Aug 2003
Posts: 19
Moscow, Russia
[quote=Marco Kalter]Aren't there standard DDE messages to open a file? [/quote]
How to open database object with DDE in PL/SQL Developer, logged in proper database?

Re: wish: open package from database by command line
Nashev #40315 05/13/11 09:49 AM
Joined: Aug 1999
Posts: 22,226
Member
Offline
Member
Joined: Aug 1999
Posts: 22,226
For a database object this will indeed not be possible.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 14 (0.008s) Memory: 2.5200 MB (Peak: 3.0429 MB) Data Comp: Off Server Time: 2024-06-02 07:48:17 UTC
Valid HTML 5 and Valid CSS