Using Tools Configuration - Session - SQL Script

[Frank Ginfrida]

Does anyone have an example configuration for creating a Tool to execute a sql script from a directory?

I'm currently running PL/SQL 7.1 (soon to be upgraded to 12).

When I create the tool as a menu item, I give the Tools Configuration menu:
- A name (no spaces)
- Type: Sessions
- Under Executable/Script I enter the full path and file name: D:\VSS Working Folder\Utilities - Batch Jobs\Audit_File.sql
- Give it a menu location
- Select "SQL Window" as the Window Type

When I execute the Tool, PL/SQL shows busy for 10-15 sec. then nothing is returned. Clearly there's something wrong in the configuration.

I've also tried copying the sql to the root directory (to eliminate any chance that of a name in the path causing the problem). Same result.

Any help would be greatly appreciated.

 

[Marco Kalter]

For a session tool the SQL script is executed within the context of the session of the SQL Window. There will not be any feedback, unless there are errors.

 

[Frank Ginfrida]

Marco,

Thank you. I have a large number of scripts that are will return information from the data base for troubleshooting and other purposes.

I'd like to be able to execute the scripts from the toolbar and see the return information. Is there a way to do so?

 

[Marco Kalter]

You should probably execute these scripts in a SQL Window. If the script is a single select statement you can use the Report Window instead. Reports can be added the the Report menu on the File ribbon.

 

[William Robertson]

Could the spaces in the path be the issue? (Wild guess - I've never used the 'session' option, I've only ever launched SQL*Plus or cmd using 'external'.)