Working with Procedures and Functions
A code object is code that is stored in the database, such as a procedure or a function. A function returns a value. A procedure doesn't, but it can have output parameters. Some databases have more types of code objects, such as packages in Oracle, which group procedures and functions. Triggers are also code objects; see Creating a Trigger.
In DbVisualizer Pro, you create code objects using a dialog, and edit and compile them in a code editor, such as the Procedure Editor, in the Object View tab of the object. You can execute procedures and functions from the editor or in SQL Commander.