PLSQL-JSON/uninstall.sql at master · yutianc/PLSQL-JSON · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
/*
 *
 * NAME
 *	uninstall.sql
 *
 * AUTHOR
 *	Dieter Oberkofler
 *
 * FUNCTION
 *	Uninstall the plsql_json objects
 *
 */


DECLARE
	object_does_not_exist EXCEPTION;
	PRAGMA EXCEPTION_INIT(object_does_not_exist, -4043);
BEGIN
	BEGIN EXECUTE IMMEDIATE 'DROP PACKAGE json_utils';	EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP PACKAGE json_parser';	EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP PACKAGE json_debug';	EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP TYPE json_array';		EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP TYPE json_object';	EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP TYPE json_value';		EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP TYPE json_nodes';		EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP TYPE json_node';		EXCEPTION WHEN object_does_not_exist THEN NULL; END;
	BEGIN EXECUTE IMMEDIATE 'DROP TYPE json_keys';		EXCEPTION WHEN object_does_not_exist THEN NULL; END;
END;
/