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

    ORA-02263 when creating Report on Web Service Result




      I'm using Application Express 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 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.