Question Tools Configuration

[tseck]

Hi all,

i'm trying to integrate some useful sql-scripts via the tools-menu. Calls to executables (type=external) work fine, but trying to call a type=session tool doesn't seem to work. I'm using plsqldev 6.0.4

Example: File test.sql with the 1-line contents

select 1 from dual;

linked to the tools-menu with type=session and description=Test

When clicking the execute-button from the configuration menu or when using the new menuitem Test on the tools-menu, no output is generated.

I tried this with various active windows and different sessions/connections.

What am I doing wrong?

Thanx, Thomas.

 

[LMW]

Hello,

with session-tools the given sql-script will execute in current session (active window).
This is useful for changing nls-parameters or other session parameters (timed_statistics, sql-trace,...)

It will not open a new window (in a new session), what I would like to have, too.
Instead of this use reports or standard queries linked to a special table/view.

Wilhelm

 

[tseck]

I think it doesn't execute at all.

i.e.: open a new command-window (=active-window)
then execute a session-tool with a sql that selects some rows => no output is generated within the command-window

 

[Marco Kalter]

That is correct. The SQL is executed in the current session, but the results are not displayed, since this is not part of the Session Tool functionality. You should probably create a report and add it to the report menu.