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
Messages: 7
Registered: July 2007
Junior Member

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 (Sun Unix)

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

Report message to a moderator

Previous Topic: JDeveloper NOT Starting
Next Topic: XML Query Syntax Problem
Goto Forum:

Current Time: Mon Aug 21 07:18:35 CDT 2017

Total time taken to generate the page: 0.01484 seconds