Example 10-13: Multi-table patient profile with DBXML

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