Oracle PL/SQL calls XPath to access XML content

procedure PRC _ Save the configuration (prm_data in out long,
prm_appcode out number,
prm_error out varchar2) is

XML xmltype;
V_str varchar2 (1000 );
Aclob clob;
Begin
Prm_appcode: = pkg_a_macro.def_ OK;
Select Config into aclob from config where config_id = 1;
XML: = xmltype. createxml (aclob );
XML: = xml. Extract ('/config/modules/module [@ ID = "104"]/item [@ ID = "1"]/insure ');
V_str: = xml. Extract ('/insure @ Code'). getstringval;
Dbms_output.put_line (TRIM (v_str ));
Exception
When others then
Prm_appcode: = pkg_a_macro.def_err;
Prm_error: = 'Save configuration: '| prm_error |'; '| sqlerrm;
End PRC _ Save the configuration;

The xmltype cannot be saved through JDBC. Therefore, you can only save it as clob, and then create an xmltype from clob through create.