Working with Procedures Using a Data Definition File
Go Up to Working with Procedures
To create or alter a procedure through a data definition file, follow these steps:
- 1. Use a text editor to write the data definition file.
- 2. Save the file.
- 3. Process the file with
isql. Use this command:
isql -input filename database_name
- where <filename> is the name of the data definition file and <database_name> is the name of the database to use. Alternatively, from within isql, you can process the file using the command:
SQL> input filename;
If you do not specify the database on the command line or interactively, the data definition file must include a statement to create or open a database.
The data definition file can include:
- Statements to create, alter, or drop procedures. The file can also include statements to create, alter, or drop exceptions. Exceptions must be created before they can be referenced in procedures.
- Any other
isqlstatements.