Example 10-12: XML stock portfolio using DBXML

CREATE PROCEDURE StockQuotesDbxml( id NUMBER ) IS
BEGIN
  Dbxml.Query('SELECT q.symbol as Symbol, 
                      q.price  as Price, 
                      q.change as Change
                 FROM quotes q, portfolio_stocks ps
                WHERE q.symbol = ps.symbol
                  AND ps.owner = ' || id,
   theDocElement => 'PORTFOLIO',
   tableElement  => 'QUOTE' );
END;