Execute Procedures / Functions


To execute procedure or function select "Execute..." menu item from right click popup menu in Object View or right click on a procedure name in script tab and select first menu item.

If procedure requires arguments than you will be presented with dialog box to enter them.

To specify NULL value leave Value column blank.

To specify empty string type '' (two single quotes) in Value column.

Red foreground color in Type column indicated required field. Green indicates that column has default value

You can use "Script EXECUTE" menu option if you wish to execute procedure from script tab.

To specify parameters in this case select generated code and use "Replace Template Parameters" menu option to specify initial values