Skip to content

Add Oracle-compatible DBMS_OUTPUT package implementation #998

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
gaoxueyu merged 20 commits into from
Jan 9, 2026
Merged

Add Oracle-compatible DBMS_OUTPUT package implementation #998

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
20 commits
Select commit Hold shift + click to select a range
67d6aa3
Add DBMS_OUTPUT package in ivorysql_ora extension
rophy Dec 2, 2025
4da23a0
fix: store NULL and empty string as NULL in DBMS_OUTPUT
rophy Dec 2, 2025
f2f615b
feat: add 32767 byte line length limit to DBMS_OUTPUT
rophy Dec 3, 2025
0324f53
fix: address CodeRabbit review feedback for DBMS_OUTPUT
rophy Dec 3, 2025
123346e
docs: clarify Oracle compatibility in DBMS_OUTPUT comments
rophy Dec 3, 2025
1e1b169
test: update opr_sanity expected output for DBMS_OUTPUT types
rophy Dec 3, 2025
1d13485
test: update opr_sanity_1.out expected output for DBMS_OUTPUT types
rophy Dec 3, 2025
02a00e0
fix: address PR review comments for DBMS_OUTPUT
rophy Dec 24, 2025
60dfb27
fix: make DBMS_OUTPUT buffer session-scoped like Oracle
rophy Dec 24, 2025
56df5f2
test: add regression tests for session-scoped DBMS_OUTPUT buffer
rophy Dec 25, 2025
1804eae
test: add regression test for VARCHAR2 OUT parameter compatibility
rophy Dec 25, 2025
542ec40
fix: add VARCHAR2 overloads for DBMS_OUTPUT OUT parameters
rophy Dec 25, 2025
c321421
feat: implement dynamic ring buffer for DBMS_OUTPUT
rophy Dec 25, 2025
8d14b76
build: add DBMS_OUTPUT to meson build
rophy Dec 25, 2025
454aaaa
refactor: replace ring buffer with linked list for DBMS_OUTPUT
rophy Dec 29, 2025
816fdc3
fix: address PR review comments for DBMS_OUTPUT
rophy Jan 5, 2026
df692a4
test: add regression test for DISCARD ALL clearing DBMS_OUTPUT buffer
rophy Jan 5, 2026
b2480af
fix: clear DBMS_OUTPUT buffer on DISCARD ALL/PACKAGES
rophy Jan 6, 2026
e0d4a55
fix: update comment to reflect ProcessUtility hook implementation
rophy Jan 6, 2026
d771411
fix: add ora_dbms_output_reset prototype to shared header
rophy Jan 6, 2026
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
4 changes: 3 additions & 1 deletion contrib/ivorysql_ora/Makefile
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -25,6 +25,7 @@ OBJS = \
src/builtin_functions/datetime_datatype_functions.o \
src/builtin_functions/numeric_datatype_functions.o \
src/builtin_functions/misc_functions.o \
src/builtin_packages/dbms_output/dbms_output.o \
src/merge/ora_merge.o \
src/sysview/sysview_functions.o \
src/xml_functions/ora_xml_functions.o \
Expand Down Expand Up @@ -71,7 +72,8 @@ ORA_REGRESS = \
ora_sysview \
ora_like_operator \
ora_xml_functions \
dbms_utility
dbms_utility \
ora_dbms_output

SHLIB_LINK += -lxml2

Expand Down
Loading