Oracle Rest Data Services (ORDS) (MOSC)

MOSC Banner

Using Template Directives in REST Data Source is not working

edited Sep 18, 2026 9:18AM in Oracle Rest Data Services (ORDS) (MOSC) Question

I have created a simple example to test Template Directives in REST Data Sources for a presentation I'm giving. Everything is created on a free oracleapex.com Account. For this I've built the following two tables:

CREATE TABLE "JUR_PERS"
( "NAME" VARCHAR2(240 CHAR) NOT NULL ENABLE,
"USTNR" VARCHAR2(11 CHAR) NOT NULL ENABLE,
"ID" RAW(16),
CONSTRAINT "JUR_PERS_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
) ; CREATE OR REPLACE EDITIONABLE TRIGGER "JUR_PERS_T"
before
insert on "JUR_PERS"
for each row
begin
if :new.id is null then
:new.id := sys_guid();
end if;
end;
/
ALTER TRIGGER "JUR_PERS_T" ENABLE;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center