Example 10-15: Multi-table state profile with DBXML

CREATE PROCEDURE StateProfile( abbrev VARCHAR2 ) IS
BEGIN
  Dbxml.Query('select * from state
               where name = '''|| abbrev ||'''' ,
              includeDetails      => 'Y',
              detailExclusionList => 'COUNTRY,DOCTOR,VISIT');
END;