This is same question from sql and pl/sql forum: Re: pl/sql code to consume web service
"Oracle 11g Express Edition (sadly, no Java).
Do you know of any tool similar to axis wsdl2java to generate pl/sql web service proxy code based on wsdl file only?
I've just read that Apex is able to consume a web service.
Does it generate set of pl/sql types and/or packages.
Any suggestion would be greatly appreciated.