how to run a package in oracle
Anyways Open the Toad and Connect to DataBase by clickingon New connection and then go for Procs tab in object explorer where you can see the procedures, fuctions and packages. select the appropriate package and then right click and go for optionexec