What grants are necessary to create web service?
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