Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What grants are necessary to create web service?

Igor KortchnoïDec 4 2009 — edited Dec 10 2009
I am trying to create a web service in APEX by using example from [APEX site|http://download.oracle.com/docs/cd/E14373_01/appdev.32/e13363/web_serv.htm#CHDJEFEB] , but get a standard error : "The WSDL document was unretrievable because either the URL you supplied was invalid, your environment requires a valid proxy server address for HTTP requests and you have not defined one for this application, or a wallet needs to be configured for this instance of Application Express for HTTPS requests".

The link used in example is a simple http URL (*not https*): http://www.ignyte.com/webservices/ignyte.whatsshowing.webservice/moviefunctions.asmx?wsdl

I am able to show this link in browser.

My application does not use proxy.

I am able to create this web service in APEX running on DB (10g) installed on my workstation, but not on our company' development DB (also 10g). Apparently, some grants are missing.

Under sys, I have tried to grand execute on url_http to APEX_PUBLIC_USER and FLOWS_030100 in company' development DB . Still the same problem.

What other grants should I give and to which schema to be able to create web services?

Igor
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2010
Added on Dec 4 2009
12 comments
932 views