sqlj.remove_jar:
(1) .-0------.
|--sqlj.remove_jar--(--| Jar Name |-------,--+-deploy-+--)------|
Use the sqlj.remove_jar( ) procedure to remove a previously installed jar file from the current database.
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| deploy | Integer that causes the procedure to search for deployment descriptor files in the jar file | None | Literal Number |
If you attempt to remove a jar file that is referenced by one or more UDRs, the database server generates an error. You must drop the referencing UDRs before you replace the jar file. For example, the following SQL statements remove the jar file associated with the course_jar jar id:
DROP FUNCTION sql_explosive_reaction;
EXECUTE PROCEDURE sqlj.remove_jar("course_jar")
When you specify a nonzero number for the second argument, the database server searches through any included deployment descriptor files. For example, you might want to include descriptor files that include SQL statements to revoke privileges on UDRs in the associated jar file and drop them from the database.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]