You can use the routine editor to edit the source code
and properties of a non-PL/SQL 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.
To edit the properties or source code of a non-PL/SQL routine:
- Switch to the Data perspective.
- 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 Source page
to make changes to the CREATE statement. You can also modify
some routine options on the Configuration page.
Some options on the Configuration page are
read-only. If you make changes on the Configuration page,
click Save Changes and Regenerate Definition to
synchronize your changes with the Source page.
- For Java routines,
click the link on the Configuration page to
open the Java source in the Java editor, where you can make
modifications and save the changes. For example, click PROCEDURE.java. Otherwise, the steps for modifying options on the Configuration page
and the Source page is the same for Java routines as it is for SQL routines.
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.