DevOps, CI/CD and Automation

We are attempting to use XMLTransform() to transform xml loaded into an XMLType column using a loaded XSL stylesheet and loading an XMLType column in a new table with the transformed XML.

We get an ORA-04030: out of process memory when trying to allocate 65548 bytes

when we try to run the following:
delete stylesheet_tab where msg_type = 'test';

insert into stylesheet_tab values ('test',xmltype(xdbURIType('/home/paul/Source/xsl/test_oracle.xsl').getClob()));

drop table sample_conv2;

CREATE TABLE sample_conv2 (BIN_FK VARCHAR2(25), RESULT XMLTYPE);

INSERT INTO sample_conv2 (BIN_FK, RESULT)
select BIN_FK,
XMLTransform(sample.msg,(select stylesheet from stylesheet_tab where msg_type = 'test'))
as result
from xml_sample;

sample.msg is an XMLType column

if we skip the create table step and just do the select it runs no problem.

Oracle 9.2.0.3