Viewing and editing routines

You can use the routine editor to edit the source code and properties of a routine, such as a stored procedure or user-defined function.

About this task

If you make source code changes using the Routine editor, you must save the routine and then deploy it again to the database server to apply the changes to the server version of the routine.

Restriction:
  • Some products do not support Java routines.
  • In the Data Source Explorer, you can view routine properties but you cannot change them.

Procedure

To edit the properties or source code of a non-PL/SQL routine:

  1. In the Data Project Explorer, double-click a routine. The routine editor opens.
  2. Edit the routine as required.
    1. For SQL routines, type directly on the DDL page to make changes to the CREATE statement.
    2. For Java routines, type directly on the DDL page to make changes to the CREATE statement, or type on the Java page to modify the Java source.
    Content assistance is available in the routine editor. To use content assistance, type a schema or table name followed by a period (.) character to see a list of available tables or columns in the connection that you are working with, or press Ctrl + Space.
  3. Click File > Save to save your changes.

Results

The properties or source code of the routine are changed. If there are errors in either the SQL DDL or the Java source, a warning message is displayed and the line containing the error is annotated with an error marker.

Feedback