Skip to content

PRAGMA AUTONOMOUS_TRANSACTION Implementation #986

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 4 commits into from
Dec 18, 2025
Merged

PRAGMA AUTONOMOUS_TRANSACTION Implementation #986

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
4 commits
Select commit Hold shift + click to select a range
021f549
feat: implement PRAGMA AUTONOMOUS_TRANSACTION for PL/iSQL
rophy Dec 1, 2025
36e439f
fix: address CodeRabbit review comments for autonomous transactions
rophy Dec 1, 2025
a580f91
fix: use fixed date in autonomous transaction test for determinism
rophy Dec 3, 2025
48c46fc
fix: add package test and meson.build entry for autonomous transactions
rophy Dec 5, 2025
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
11 changes: 9 additions & 2 deletions src/pl/plisql/src/Makefile
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -39,6 +39,7 @@ rpath =

OBJS = \
$(WIN32RES) \
pl_autonomous.o \
pl_comp.o \
pl_exec.o \
pl_funcs.o \
Expand All @@ -52,13 +53,17 @@ OBJS = \

DATA = plisql.control plisql--1.0.sql

# dblink extension is required for autonomous transactions
# Install dblink into the test instance
EXTRA_INSTALL = contrib/dblink

ORACLE_REGRESS_OPTS = --dbname=$(PL_TESTDB)

REGRESS = plisql_array plisql_call plisql_control plisql_copy plisql_domain \
plisql_record plisql_cache plisql_simple plisql_transaction \
plisql_trap plisql_trigger plisql_varprops plisql_nested_subproc \
plisql_nested_subproc2 plisql_out_parameter plisql_type_rowtype \
plisql_exception
plisql_exception plisql_autonomous

# where to find ora_gen_keywordlist.pl and subsidiary files
TOOLSDIR = $(top_srcdir)/src/tools
Expand Down Expand Up @@ -87,6 +92,7 @@ install-headers: installdirs
$(INSTALL_DATA) '$(srcdir)/plisql.h' '$(DESTDIR)$(includedir_server)'
$(INSTALL_DATA) '$(srcdir)/pl_subproc_function.h' '$(DESTDIR)$(includedir_server)'
$(INSTALL_DATA) '$(srcdir)/pl_package.h' '$(DESTDIR)$(includedir_server)'
$(INSTALL_DATA) '$(srcdir)/pl_autonomous.h' '$(DESTDIR)$(includedir_server)'

uninstall-data:
rm -f $(addprefix '$(DESTDIR)$(datadir)/extension'/, $(notdir $(DATA)))
Expand All @@ -95,12 +101,13 @@ uninstall-headers:
rm -f '$(DESTDIR)$(includedir_server)/plisql.h'
rm -f '$(DESTDIR)$(includedir_server)/pl_subproc_function.h'
rm -f '$(DESTDIR)$(includedir_server)/pl_package.h'
rm -f '$(DESTDIR)$(includedir_server)/pl_autonomous.h'

.PHONY: install-data install-headers uninstall-data uninstall-headers


# Force these dependencies to be known even without dependency info built:
pl_gram.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o pl_scanner.o: plisql.h pl_gram.h plerrcodes.h pl_subproc_function.h pl_package.h
pl_gram.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o pl_scanner.o pl_autonomous.o: plisql.h pl_gram.h plerrcodes.h pl_subproc_function.h pl_package.h pl_autonomous.h
pl_scanner.o: pl_reserved_kwlist_d.h pl_unreserved_kwlist_d.h

# See notes in src/backend/parser/Makefile about the following two rules
Expand Down
Loading