DevOps, CI/CD and Automation

Appreciate a small snipped to insert xml file, its name and  an id into three different columns of a table:

Create table Table_XML ( sno number, -- this will store a running sequence number filename varchar2(100), -- this will store the file name file xmltype );

The files will be read from my local windows machine directory C:\Oracle\Xml_files\

sample xml data below:

<?xml version="1.0" encoding="iso-8859-1"?>

<!DOCTYPE ichicsr SYSTEM "http://eudravigilance.ema.europa.eu/dtd/icsr21XML.dtd">

<ichicsr lang="en">

<ichicsrmessageheader>

<messagetype>ichicsr</messagetype>

<messageformatversion>2.1</messageformatversion>

<messageformatrelease>2.0</messageformatrelease>

<messagenumb>97211</messagenumb>

<messagesenderidentifier>S</messagesenderidentifier>

<messagereceiveridentifier>TEST</messagereceiveridentifier>

<messagedateformat>204</messagedateformat>

<messagedate>201708092</messagedate>

</ichicsrmessageheader>

</ichicsr>

The encoding can be Utf-8 as well