Skip to main content
K
ktp2
Participant
July 24, 2011
Question

FlashBuilder 4.5 accessing Oracle 11gR1 database/WebSecices/WSDL

  • July 24, 2011
  • 1 reply
  • 1296 views

Hi,

I’m trying to accessOracle data using an existing stored procedure. What I have managed to do sofar is:

Get WSDL definitionusing Oracle XML DB (using an example from Oracle documentation the http callto return the WSDL has this format http://host:port/orawsv/DBSCHEMA/FN_OR_PROC?wsdl)

Testing the WSDL usingsoftware called “soapUI” executes and returns the data correctly in XML format.

Entering the same URLto Flash Builder “Connect to Data/Service” wizard and selecting WSDL option doesn’treturn an error but doesn’t either do that much (e.g. it populates the wizardbut the “Next” or “Finish” buttons don’t make the wizard to move forward). One of the reasonsmight be that there is no place (?) to define the userid/password. When I triedto include these in the URL it didn’t change anything.

Would someone have asimple example of using WSDL together with Oracle, PL/SQL, WebServices or other resources/links/adviseto help me with this?

Thanks,

ktp2

This topic has been closed for replies.

1 reply

K
ktp2Author
Participant
July 24, 2011

Hi,

did manage to get a little bit further, now the wizard reurns an error. After the wizard asked for userid/password, I can get two different results, depending on the URL I use.

With "http://development:8080/orawsv/SCOTT/GET_DESCRIPTION_5"

it returned "Unable to retrieve operations and entities from the specified WSDL"

The details then showed

"There was an error during service introspection.
WSDLException (at /soap:Envelope): faultCode=INVALID_WSDL: Expected element '{http://schemas.xmlsoap.org/wsdl/}definitions'."

With "http://development:8080/orawsv/SCOTT/GET_DESCRIPTION_5?wsdl"

the wizard doesn't return a error, the next or finish buttons just wont show the next step in the wizard.

At the same time - the precise same URL works fine in soapUI. The URL without "?wsdl" returns the correct result, the URL with "?wsdl" returns the  wsdl specification xml

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices