Tuesday, July 6, 2010

Application Express 4.0 Web Services Evaluation Guide

I just returned from ODTUG Kaliedoscope 2010, (awesome event, best one I have been to), and promised during my presentation that the Application Express 4.0 Web Services Evaluation Guide would be posted on the Application Express Web Services Integration page on OTN. Well it now is, so I kept my promise. ;)

If you missed me at ODTUG, you can see me give a very similar presentation this year at Oracle Open World. The session is at 12:30 on Thursday September 23rd, so don't get too crazy at the appreciation event the night before!

Update 7/28/2010: A patch set exception was created for the issue the Roel reported in the comments below. Log on to Metalink and search for 9848562.


Stew said...


I doubt this is your issue, but I just got the following error when I tried the Google Maps preview app:

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1577 ORA-24247: network access denied by access control list (ACL)

I'm thinking the authorization code might have expired?

Jason Straub said...


Thanks for informing me. It seems that after the upgrade, the workspace schema was not granted the proper privilege to do the callout. I will look into it.



Roel said...

That's nice Jason!
I encountered two things working on the "APEX as a REST Provider" piece:
1. You have to enable the Network Services (ACL), otherwise you run into an "The webservice was unreachable..." error.
2. When I create a Webservice Process on a Page it runs fine, but when I (try to) edit the process and press - without making any - I get :
ORA-02290: check constraint (APEX_040000.WWV_FLOW_WS_MAP_CHK) violated error updating web service parameters. Bug or feature?

Jason Straub said...


The first issue is expected and is documented at:


The second issue is definitely a bug and will be fixed in the 4.0.1 patch set.



Pat Miller said...

I could not get to your document on Web Services Evaluation Guide. It takes me to the Apex 4.0 site but I can't navigate to find your document.

Are there any other resources for CREATING RESTful services with APEX that are more interactive and not just reports--such as the implementation of a data entry form or update form that can be accessed as a web service from another application--such as a Portal, for example.


Jason Straub said...


You are right. The page is gone. I will find out what happened to it.

Regarding publishing Application Express components as a RESTful service, the only component you can currently publish is a report region.



Scott said...


Looks like this moved to here:



- Scott -

Jason Straub said...

Scott, you are right. I have updated the link.



Anonymous said...

Hi Jason,

Thank you for the information and document - it really cleared up some questions. Documentation in general has been very limited.

Would it be possible to do an example of a Amazon S3 file get or put RESTful ws (I am struggling with the APEX ws definition screen)?

Much appreciated if you could point me in the right direction.


Jason Straub said...


You are in luck. I think you are going to like my very first post of 2011. Check back later today for a new post.



Laxmi Ramanath said...

Hi Jason

I am exploring the use of Web services for gathering news using a tool like google into the db. Do you think this may be possible with 4.0 web services. I would appreciate a copy of your evaluation guide

My email id is laxmi@lameera.com

Thank you for your help in advance