Use the Code Fragments page of the New Stored Procedure wizard to specify code fragments that you want to include in the stored procedure. For non-PL/SQL stored procedures.
- 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.