2 Replies Latest reply: Dec 9, 2013 2:05 AM by swesley_perth RSS

    tabular form based on complex view

    salute-Salem

      hi all ,

      on apex 4.0 , db11gxe , firefox 24 , i am trying to create a tabular form based on a complex view , the code of it is

       

      CREATE OR REPLACE FORCE VIEW  "CP" ("CLIENT_ID", "CLIENT_NAME", "AGE", "EMAIL", "PHONE", "PAYMENT_DATE", "summary") AS

        select c.client_id , c.client_name , c.age , c.sex , c.email , c.phone ,

      p.payment_date , sum(p.amount) "summary"

      from clients c , payments p

      where c.client_id = p.client_id

      group by c.client_id , c.client_name , c.age , c.email , c.phone ,

      p.payment_date;

      and  i am facing this error when i try to run the page

       

      failed to parse SQL query: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. 

      ?