Feauture idea

[Morff]

I think about new toolbar (with "my scripts" title or something like that) or new menu item from tools menu where I can add my favorite scripts . Sometimes I need run very important script but I cannot remember where it is .. I've got 1000 scripts and sometimes I'm blind .. I think it will be fine to run important or favorite scripts from shortcut on toolbar or keyboard shortcut assigned to menu item.
What you think ?

 

[Theod]

Hi,

you are able to do that with tools\preferences\configure tools

 

[Morff]

So I try to do this .. but it isn't work :
Menu Tools -> Configure tools and
1.ctrl+insert to add item
2.on the "general" tab :
description - "My script"
type - session
executable/script - c:\program files\plsqldeveloper\scripts\my_script.sql
3.on the "button" tab :
check toolbar button
description - "My script"
choose bitmap
4.on the "options" tab :
requirements - check active session
window types - command window
"OK"
.. and when I open new command window "My script" button changes to enabled , but when I press it - nothing is happen.

Am I doing something wrong ?

 

[Theod]

Hi,

for scripts whith the type 'session' the output seems not to work.

"select 'Hallo' from dual;" i get only to live, with

type 'external'
Execetutable/Script 'sqplus.exe'
Parameters '#connect @z:\work\my_script'

If the type is 'session' the output goes elsewhere.
But the Script will be executed. If the is a Variable like '&Parmam' in the script, the Variable is ask for.

DML work's also fine, like alter session....

No more ideas, so far.

 

[Theod]

ups,

DDL, like alter session ...

 

[Morff]

Yes , you're right ..

Script is work but (as you wrote):
"If the type is 'session' the output goes elsewhere"

I ran :
begin
mypackage.myprocedure;
dbms_output.put_line('Done ...');
end;
/
and it works .. but with no message ..