I have a requirement where i need to load xml file into a mysql table using trigger.
I have written the following trigger to achieve this.
CREATE TRIGGER asdb.payment_test AFTER INSERT ON asdb.abc1 FOR EACH ROW BEGIN load XML local infile 'D:\\New Folder\\form.xml' into table asdb.abc rows identified by '<ApplicantName>'; END; | DELIMITER ;
Its giving the following error:
LOAD XML is not allowed in stored procedures
I have googled this to find a solution. I have found that load xml is not allowed in stored procedure since mysql version 5.0.7 (http://stackoverflow.com/questions/16288700/load-xml-via-mysql-stored-procedure)
We are using mysql version 5.5. Is there any possible way to achieve this?