two subqueries in sql transformer xml

[Argyn Kuketayev]

I want to put two subqueries in xml file for sql transformer. It doesn't
work , says: "<error>ORA-00933: SQL command not properly ended</error> "

XML file is here:

=============
<?xml version="1.0"?>

<page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>

 <title>Hello</title>
 <content>
  <para>This is my first Cocoon2 page filled with sql data from PLS!</para>

  <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> 
   <query>
        select
         material_TYP_id,
         material_TYP_DESC,
         REV_NUM,
         COMMENTS
        from
         pa_material_type
   </query>
   <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
    <query name="facility">
        select
         i.FACILITY_ID,
         f.FACILITY_DESC,
         i.REORDER_VALUE,
         i.INVENTORY_VALUE
        from
         PA_MATERIAL_INVENTORY i,
         PA_FACILITY f
        where
         i.MATERIAL_TYP_ID = '<ancestor-value sql:name="material_TYP_id"
sql:level="1"/>'  
         and i.FACILITY_ID = f.FACILITY_ID  

    </query>

    <query name="component">
        select distinct
         m.CPNT_TYP_ID,
         m.CPNT_ID,
         m.REV_DTE,
         c.REV_NUM,
         c.CPNT_TITLE 
        from
         PA_CPNT_MATERIAL m,
         PA_CPNT c
        where
         m.MATERIAL_TYP_ID = '<ancestor-value sql:name="material_TYP_id"
sql:level="1"/>' 
         and m.CPNT_TYP_ID = c.CPNT_TYP_ID
         and m.CPNT_ID = c.CPNT_ID
         and m.REV_DTE = c.REV_DTE

    </query>

   </execute-query>

  </execute-query>
 </content>
</page>
===============

thanx for help



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>