1 person found this helpful
Just a thought - Have you tried it with other APEX environments you own. There might be some mis-steps/mis-configurations during the setup of the environment you're having issue with.
Thank you for your reply.
I've tried it with other environments (also version 4.2.1.00.08) and I get the exact same error.
Is it possible there's a bug regarding creating report on web service result, in that particular version?
Thank you, I've tried it already, it's more or less the same and I get the same error: ORA-20001: Unable to create form on table. ORA-02263: need to specify the datatype for this column.
I've created a test environment with the exact same APEX version, on 11g XE database, and everything works fine.
The database we actually have, which I've failed to mention, is 10g.
Could that be the problem? Does anyone know of any reason why creating a report on web service result might not work on 10g database?
Thanks once again.
I wasn't able to solve the original problem, but I was able to recreate the process manually, using APEX_WEB_SERVICE.PARSE_RESPONSE function, documented here:http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21676/apex_web_service.htm#autoId10
Thanks again for your help!