Yes, i used oral sedation to manage uncooperative pediatric patient who need dental treatment, oral midazolam is considered safe and effective sedative agent but its short duration of action limit its use to simple to moderate treatment
As Ali said, Midazolam is an extremely handy pre-medication element specially in children. However, there are some concerns. The most dreaded one is the possibility of apnea occurrence. Therefore, the people using this medication and other similar medications are required to know airway management skills or at least bag-mask ventilation.
We usually administer Triclofos at 50mg/kg in the syrup form, but in some cases have resorted to midazolam nasal spray for sedation purposes.
As far as safety profile was concerned, no adverse events have occurred till now with either drug.
Ease of administration was much more with midazolam nasal spray.
In a few cases where I have been present on site as attending pediatrician, I have had to give Inj. Midazolam i/v, but I prefer to use a dosage of 3/4th of the total -and till now haven't had any issues.
I've used Midazolam with N2O (before 30 Min) very often, the child get it bei Oral way (mixed with Juice) or bei Nasal (Infiltration), and was very effective for extrem afraid child.
I have three publications on the topic. Please go to my RG site. You may read in detail about your question. I have a review article in the area that should provide detail of your interest.