how to insert xml data into table using stored procedure whit mysql ?

I need to create a stored procedure , this procedure have a parameter that is xml. this is the xml

So i need to insert oportunidad in the table oportunidad and insert each producto in the table detalle (a lot of insert). I need to a example because I no have idea. thanks

pdt : I use mysql and laravel

via Chebli Mohamed