The show_cached_plan_in_xml function returns a showplan output in XML for a statement in cache.
You must enable the statement cache before using show_cached_plan_in_xml.
See "Displaying Query Optimization Strategies and Estimates" in the Performance and Tuning Series: Query Processing and Abstract Plans