Example 5-25: Serving SQL query results for an accepted submission in XML

CREATE OR REPLACE FUNCTION submissionXML( id NUMBER ) RETURN CLOB IS
  query VARCHAR2(100);
BEGIN
  query := 'select *
              from accepted_submission
             where id = '||id;

  RETURN xmlgen.getXML(query);

END;