7 Replies Latest reply on Oct 22, 2013 8:20 AM by anai

    ORA-02263 when creating Report on Web Service Result

    anai

      Hi,

       

      I'm using Application Express 4.2.1.00.08 and I'm having problems creating a report on web service result.

      This is the tutorial I'm using: http://docs.oracle.com/cd/E14373_01/appdev.32/e13363/web_serv.htm (yes, I realize it's intended primarily for APEX 3.2).

       

      I am able to create the web service, but when creating a report on web service result, I get the following error in the last step:

      ORA-20001: Unable to create form on table. ORA-02263: need to specify the datatype for this column.


      I have tried creating a report on the same web service result on apex.oracle.com (Application Express 4.2.1.00.08) and I don't get the error, and I am able to create the report.

       

      The same thing happens with another web service, so I'm puzzled.


      What could be the problem?


      Thank you.