I have not yet had the need (or the desire...) to work with Sharepoint from PL/SQL, but it would be quite easy to create a PL/SQL library package to interface with the Sharepoint web services, similar to the Exchange package listed above. Perhaps I will revisit this topic sometime in the future... ?

2 comments:

I am following with interest the development of the alexandria library, and especially the flex_ws_api. I have done some testing and it is indeed very simple to call a soap service with this package. However, while I am no expert in using soap services, I have to call a soap service that expects a certificate for authentication. I have succeeded to get data by using soapui by setting this .p12 certificate as keystore. However, I am not able to import this certificate via the wallet manager. When I call the service with make_request I get an access denied message. Do you, as an expert, know what the cause can be or give me some hints?

@Piotr: Note that the FLEX_WS_API (written by Jason Straub) was the basis for the APEX_WEB_SERVICE package included with Apex, so if you have at least Apex 4 then I recommend you use APEX_WEB_SERVICE to call web services.

You say that you are "not able to import this certificate via the wallet manager", why not? Do you get an error message?

"When I call the service with make_request I get an access denied message" -- please provide the exact error message.

Also, what is your Oracle version and what is the operating system it runs on?

About Me

I have been working as a consultant and software developer for 18 years (since 1997), with a special passion for relational databases. I have done a fair share of work using Microsoft tools (including SQL Server, VB, ASP, .NET and C#) and other tools (most notably Delphi), but my favorite tool is the Oracle database with PL/SQL and Apex.