EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Creating/editing procedure


Use the Procedure tab of Procedure Editor to create/edit a stored procedure and specify its properties.

 

Procedure Editor - Editing procedure definition

 

Name

View the name of the procedure being edited or created.

 

Schema

View schema in which the procedure will be created.

 

The lower area of the editor window allows you to specify the procedure definition. The DDL tab will display the changes made to the procedure specification.

 

For your convenience the code folding, syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query data and Using the context menu.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.