CREATE PROCEDURE PatientProfile( id NUMBER ) IS BEGIN Dbxml.Query('select * from patient where id = '|| id , includeDetails => 'Y', detailExclusionList => 'FACILITY'); END;