Toad World® Forums

Generating a package...


#1

Generating a package…


#2

Hi all,

Is there a fast way to create a PL/SQL package from existing procedures with Toad 10 or do I have to go for bunch of copies and pastes ?
I haven’t seen anything obvious in the menus, icons or doctoad@yahoogroups.com

Many thanks.

JMA


#3

There’s a Refactor > Extract Procedure feature you could investigate,
but I don’t think it will do what you’re looking
for…it’s more for creating new procedures out of existing PL/SQL
blocks.


#4

OK, so the requested enhancement could be:

identify a set of procedures and functions by clicking on a list of
checkboxes showing the available ones

provide a package name

have Toad create a package and package body that includes them

perhaps with options for ordering them within the package and for deleting
the originals when done

Might be an interesting refactoring opportunity.

    • jim