running a package in pl/sql dev

[Saheem]

Hi

Is it possible in PL/SQL dev to run a pl/sql package as a report. here is the scenario.

I have a pl/sql package which validates tables against a set of criterias with the table name as the parameter passed in.

I was all my colleagues to use this when ever they create or edit a table.

Can this be used a standard report?
Or can it be fired from a menu?
Or is there any other way besides running the package directly from the database?

 

[Marco Kalter]

I think the best solution is to use the Browser Extender Plug-In. It allows you to add items to object popups. For example, you could define a "Check criteria" extension that is available when you right-click on a table. This extension can run a Report or SQL script that takes the table name as a parameter.

You can find the Plug-Ins here:

http://www.allroundautomations.com/plsqldevplugins.html

Note that for the Browser Extender there is a freeware version (2.0), and a commercial version (2.5).