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.