qubiton-oracle/uninstall.sql at main · qubitonhq/qubiton-oracle · 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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
--------------------------------------------------------------------------------
-- uninstall.sql
-- Removes all QubitOn Oracle connector objects.
-- Run this to cleanly uninstall the connector.
--
-- Usage:
--   @uninstall.sql
--
-- WARNING: This drops all QubitOn tables (including audit logs) and packages.
--          Export any needed data before running.
--------------------------------------------------------------------------------

SET SERVEROUTPUT ON SIZE UNLIMITED
SET DEFINE OFF

PROMPT ============================================================
PROMPT  QubitOn Oracle PL/SQL Connector — Uninstall
PROMPT ============================================================
PROMPT
PROMPT WARNING: This will remove ALL QubitOn objects and data.
PROMPT Press Ctrl+C to cancel, or Enter to continue...
PAUSE

-- Step 1: Drop packages (reverse dependency order)
PROMPT Dropping packages...

BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE qubiton_ebs_pkg';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_EBS_PKG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_EBS_PKG not found (skipped)');
END;
/

BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE qubiton_validate_pkg';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_VALIDATE_PKG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_VALIDATE_PKG not found (skipped)');
END;
/

BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE qubiton_api_pkg';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_API_PKG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_API_PKG not found (skipped)');
END;
/

-- Drop test package (depends on types, api_pkg, validate_pkg)
BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE qubiton_test_pkg';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_TEST_PKG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_TEST_PKG not found (skipped)');
END;
/

BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE qubiton_types';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_TYPES');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_TYPES not found (skipped)');
END;
/

-- Step 2: Drop tables
PROMPT Dropping tables...

BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE qubiton_api_log PURGE';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_API_LOG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_API_LOG not found (skipped)');
END;
/

BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE qubiton_validation_cfg PURGE';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_VALIDATION_CFG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_VALIDATION_CFG not found (skipped)');
END;
/

BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE qubiton_config PURGE';
    DBMS_OUTPUT.PUT_LINE('  Dropped QUBITON_CONFIG');
EXCEPTION WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('  QUBITON_CONFIG not found (skipped)');
END;
/

PROMPT
PROMPT ============================================================
PROMPT  Uninstall complete. All QubitOn objects have been removed.
PROMPT ============================================================

SET DEFINE ON