Can a select with extract be used in Reports 11.1.1.6?

We are just starting to plan for using XML data and so we are climbing the learning curve.

We use Reports 11.1.1.6

I am looking for information on using "select extract(xmltype_col, "xpath pattern") as display_name into variable_name from table_with_xmltype_col" in a program unit of my report.

Our attempt (which query works in sqlplus)

PROCEDURE t IS
  v_date varchar2(4096);
  v_num varchar2(4096);

BEGIN
   select
          extract(raw_trxn_image, '//ShipmentNotice/Shipment_Document.Shipment_Date.DateTime/text()').getstringval() ,
          extract(raw_trxn_image, '//ShipmentNotice/Shipment_Document.Contract.Contract_Document/Contract_Document.Contract_Identification.Identifier/text()').getstringval()