How to Pass XML as Parameter to Stored Procedure in Oracle
Follow exactly the steps of PLSQL block and change the XML data with your XML data and change the procedure p_xml_dummy with your stored procedure name. It can be function also method is same.
DBMS_LOB.CREATETEMPORARY (v_XML, TRUE);
P_XML_DUMMY (TO_CLOB (‘<main>