Home » Developer & Programmer » JDeveloper, Java & XML » PL/SQL Cookie management when consuming external web service
PL/SQL Cookie management when consuming external web service [message #272272] Thu, 04 October 2007 06:49
marwi
Messages: 7
Registered: July 2007
Junior Member
Hello

I am trying to use an external webservice from within an Oracle 10g database (database=client).
I have the WSDL for the web service, and have successfully imported the JPub-generated Java classes and PL/SQL wrappers to the database.
I am also able to use the web service, but a small detail is missing:

The web service returns a cookie, that has to be set for all subsequent calls to the web service.

How (if at all possible) is this achieved, when I only have the limited PL/SQL wrappers at my disposal?

I have tried to call the (object).setMaintainSession(), and set the value to true (=1 for PL/SQL), but no help there...

I have tried the OWA_COOKIE, OWA, UTL_HTTP packages to see if I can retrieve the cookie from the response in any way, but so far without success.

Any help would be greatly appreciated.

Best regards
Martin Wittrup

System-info: Oracle 10.2.0.3 (Sun Unix)

[Updated on: Thu, 04 October 2007 08:12]

Report message to a moderator

Previous Topic: Parsing XML in Oracle 9i
Next Topic: Call StoreProcedure
Goto Forum:
  


Current Time: Thu Nov 21 22:54:46 CST 2024