From e1752ca3820690c158cd73fac9a9f322a44484c4 Mon Sep 17 00:00:00 2001
From: Andrew-Dunning-NNL
 <67964561+Andrew-Dunning-NNL@users.noreply.github.com>
Date: Mon, 20 Mar 2023 14:14:05 -0400
Subject: new package py-oracledb (#36191)

* new package py-oracledb

* py-oracledb use python3.6:
---
 .../repos/builtin/packages/py-oracledb/package.py  | 31 ++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 var/spack/repos/builtin/packages/py-oracledb/package.py

diff --git a/var/spack/repos/builtin/packages/py-oracledb/package.py b/var/spack/repos/builtin/packages/py-oracledb/package.py
new file mode 100644
index 0000000000..ff69ddd928
--- /dev/null
+++ b/var/spack/repos/builtin/packages/py-oracledb/package.py
@@ -0,0 +1,31 @@
+# Copyright 2013-2022 Lawrence Livermore National Security, LLC and other
+# Spack Project Developers. See the top-level COPYRIGHT file for details.
+#
+# SPDX-License-Identifier: (Apache-2.0 OR MIT)
+
+from spack.package import *
+
+
+class PyOracledb(PythonPackage):
+    """Python-oracledb is the new name for the Python cx_Oracle driver.
+    The python-oracledb driver is an open source module that enables
+    Python programs to access Oracle Database."""
+
+    homepage = "https://oracle.github.io/python-oracledb/"
+    pypi = "oracledb/oracledb-1.2.2.tar.gz"
+
+    version("1.2.2", sha256="dd9f63084e44642b484a46b2fcfb4fc921f39facf494a1bab00628fa6409f4fc")
+
+    depends_on("py-setuptools@40.6.0:", type="build")
+    depends_on("py-cryptography@3.2.1:", type=("build", "run"))
+    depends_on("py-cython", type="build")
+    depends_on("python@3.6:", type=("build", "run"))
+    depends_on("oracle-instant-client", type="run", when="impl=thick")
+
+    variant(
+        "impl",
+        default="thick",
+        description="Client Implementation",
+        values=("thick", "thin"),
+        multi=False,
+    )
-- 
cgit v1.2.3-60-g2f50