5 files changed, 72 insertions, 0 deletions

diff --git a/databases/py-oracledb/Makefile b/databases/py-oracledb/Makefile
new file mode 100644
index 000000000000..ea04c31650d2
--- /dev/null
+++ b/databases/py-oracledb/Makefile
@@ -0,0 +1,24 @@
+PORTNAME=	oracledb
+DISTVERSION=	4.0.1
+CATEGORIES=	databases python
+MASTER_SITES=	PYPI
+PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
+
+MAINTAINER=	python@FreeBSD.org
+COMMENT=	Python interface to Oracle database
+WWW=		https://oracle.github.io/python-oracledb
+
+LICENSE=	APACHE20
+
+BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}setuptools>0:devel/py-setuptools@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}wheel>0:devel/py-wheel@${PY_FLAVOR}
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}typing-extensions>=4.14.0:devel/py-typing-extensions@${PY_FLAVOR}
+TEST_DEPENDS=	${PYTHON_PKGNAMEPREFIX}anyio>0:devel/py-anyio@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}numpy>0:math/py-numpy@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pandas>0:math/py-pandas@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pyarrow>0:databases/py-pyarrow@${PY_FLAVOR}
+
+USES=		python
+USE_PYTHON=	autoplist cryptography cython pep517 pytest
+
+.include <bsd.port.mk>
diff --git a/databases/py-oracledb/distinfo b/databases/py-oracledb/distinfo
new file mode 100644
index 000000000000..f97f8f70eac3
--- /dev/null
+++ b/databases/py-oracledb/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1782325415
+SHA256 (oracledb-4.0.1.tar.gz) = 34bbea44423ed8b24093aa859ca7ee9b6e76ea490f9acdc5f6ff01aa1083e343
+SIZE (oracledb-4.0.1.tar.gz) = 879077
diff --git a/databases/py-oracledb/files/patch-pyproject.toml b/databases/py-oracledb/files/patch-pyproject.toml
new file mode 100644
index 000000000000..a379ffab6d57
--- /dev/null
+++ b/databases/py-oracledb/files/patch-pyproject.toml
@@ -0,0 +1,25 @@
+remove after devel/py-setuptools is updated to at least 77.0.0
+
+--- pyproject.toml.orig	2026-05-19 17:21:53 UTC
++++ pyproject.toml
+@@ -1,6 +1,6 @@ requires = [
+ [build-system]
+ requires = [
+-    "setuptools >= 77.0.0",
++    "setuptools",
+     "wheel",
+     "cython ~= 3.2",
+ ]
+@@ -11,12 +11,6 @@ authors = [{name = "Anthony Tuininga", email = "anthon
+ description = "Python interface to Oracle Database"
+ keywords = ["Oracle", "database"]
+ authors = [{name = "Anthony Tuininga", email = "anthony.tuininga@oracle.com"}]
+-license = "UPL-1.0 OR Apache-2.0"
+-license-files = [
+-    "LICENSE.txt",
+-    "THIRD_PARTY_LICENSES.txt",
+-    "NOTICE.txt",
+-]
+ classifiers = [
+     "Development Status :: 5 - Production/Stable",
+     "Intended Audience :: Developers",
diff --git a/databases/py-oracledb/files/patch-setup.cfg b/databases/py-oracledb/files/patch-setup.cfg
new file mode 100644
index 000000000000..39b3361f24f4
--- /dev/null
+++ b/databases/py-oracledb/files/patch-setup.cfg
@@ -0,0 +1,15 @@
+remove after devel/py-setuptools is updated to at least 77.0.0
+
+--- setup.cfg.orig	2026-05-19 17:22:01 UTC
++++ setup.cfg
+@@ -1,3 +1,10 @@
++[metadata]
++license = UPL-1.0 OR Apache-2.0
++license-files =
++    LICENSE.txt
++    THIRD_PARTY_LICENSES.txt
++    NOTICE.txt
++
+ [egg_info]
+ tag_build = 
+ tag_date = 0
diff --git a/databases/py-oracledb/pkg-descr b/databases/py-oracledb/pkg-descr
new file mode 100644
index 000000000000..2415b2b49b2f
--- /dev/null
+++ b/databases/py-oracledb/pkg-descr
@@ -0,0 +1,5 @@
+The python-oracledb driver is the widely used, open-source Python
+extension module allowing Python programs to connect directly to
+Oracle Database with no extra libraries needed. The module is built
+with Cython for safety and speed. It is lightweight and high-performance.
+It is stable, well tested, and has comprehensive documentation.