Use the Code Fragments page of the New Stored Procedure wizard
to specify code fragments that you want to include in the stored procedure.
- Header fragment
- Specify the full path to a file that includes a code fragment that you
want to insert at the start of the routine.
- Variable declaration fragment
- For SQL routines only: Specify the full path to a file that includes a
code fragment that declares variables.
- Exception handler fragment
- For SQL routines only: Specify the full path to a file that includes a
code fragment that handles exceptions.
- Pre-return fragment
- For SQL routines only: Specify the full path to a file that includes a
code fragment that will run before the results of the routine are returned.
- Imports fragment
- For Java™ routines only: Specify the full path to a file
that includes additional import statements.
- Data fragment
- For Java routines only: Specify the full path to a file
that includes class variable declarations.
- Method fragment
- For Java routines only: Specify the full path to a file
that includes class methods that you want to add to the routine.