Toad World® Forums

running an Anonymous block....


#1

hi ,

Can i run an anonymous block with this code tester…as code tester is able to run only those objects which are present in the database like procedure,function and packages…i had created various script for creating table and inserting data into it and many scripts alike…can you please help me out…


#2

Here is a situation where a best practice and product limitation go nicely hand in hand!

So…no, you cannot directly test an anonymous block. You can only test programs stored in the DB.

But…here’s the BP part: I think it generally makes sense to take those anon. scripts and move them inside packages and then run the procedures in the package. You get more flexibility this way, and you can analyze and manage your code base more effectively.

SF