ORA-01722: Invalid Number when using form/report on RESTful service rfrence
patfmndMay 20 2013 — edited May 21 2013Hi,
I am on Apex 4.2.2 and Listener 2.1. I created a Restful service reference that tests successfully and I see the results expected, however, when I try to create a form and report based on the RESTful service reference I keep getting the ORA-20001: Unable to create form on table. ORA-01722 invalid number so I can't use the RESTful service and I have no idea how to workaround this issue or troubleshoot it. I don't understand the error either, since I am not creating a form on a table. The form is only used to pass a parameter to the RESTful service and the parameter is just a string both in the parameter definition AND in the underlying query (varchar2).
Pat