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;