Executing SQL Scripts (Wish)

[ams]

Hello !

I am searching for a simplification and want to make a suggestion. (If it's already implemented and I haven't found it, pls give me a hint...)

I very often have the situation that after coding of a procedure I want to test it with a defined environment of table data. Therefore I always open a command window and call a SQL-Script by typing

@d:\projects .. bla bla ...\xyz.sql

Do you think its possible to provide a mechanism that allows a user to insert buttons, that call a SQL Script when pressed. Path and Scriptname has to be configured in the preferences.

Posssible ?

Bye from Hamburg,
Andree

 

[Marco Kalter]

Have you checked out the Tools Configuration in PL/SQL Developer 6.0? It allows you to define session tools. A session tool can run a SQL script, and optionally take input parameters. The tool can be added to the menu and/or to the toolbar for quick access.

 

[ams]

YES !
That's all I needed. Thank you.

(Would have wondered me, if PLSDev does not have a solution already inside. There is nearly nothing missed, I think. Great tool !!)