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:
- In the Data Project Explorer, double-click a routine. The routine editor opens.
- Edit the routine as required.
- For SQL routines, type directly on the DDL page
to make changes to the CREATE statement.
- 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.
- Click 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.