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;