WS-Security PL/SQL Forms

Posted on 16th Feb 2014 07:03 pm by admin

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
Forms 32 Bit Version (Production)


I have an application in Forms (web mode). That application must now use a web service.
I therefore develop a procedure called this service and it works fine using HTTPS (Web Service Test on https).
The problem is that now I must touch on the same web service that has been secure with WS-Security.
How do I add headers security, sign the message ... .

All ideas are welcome.

Thank you beforehand.

For those interested, here's the code:
(Warning, this is only a test, no param, ... , but the ultimate goal is to call this procedure in Forms).

CREATE OR REPLACE procedure test_ws_fedict
http_req utl_http.req;
http_resp utl_http.resp;
request_env varchar2(32767) DEFAULT NULL;
response_env varchar2(32767) DEFAULT NULL;
-- Set proxy details if no direct net connection.
UTL_HTTP.set_proxy('http://:@', NULL);
||'Ceci est un test accent "
dbms_output.put_line('Length of Request:' || length(request_env));
dbms_output.put_line ('Request: ' || request_env);
UTL_HTTP.set_wallet ('file:/Orasoftware/Oracle_wallet',);
http_req := utl_http.begin_request('','POST', utl_http.HTTP_VERSION_1_1);

utl_http.set_header(http_req, 'Content-Type', 'text/xml; charset=utf-8');
utl_http.set_header(http_req, 'Content-Length', length(request_env));
utl_http.set_header(http_req, 'SOAPAction', '"Echo"');
utl_http.write_text(http_req, request_env);
http_resp := utl_http.get_response(http_req);
dbms_output.put_line('Response Received');
dbms_output.put_line ( 'Status code: ' || http_resp.status_code );
dbms_output.put_line ( 'Reason phrase: ' || http_resp.reason_phrase );
utl_http.read_text(http_resp, response_env);
dbms_output.put_line('Response: ');
when others then
end test_ws_fedict;

No comments posted yet

Your Answer:

Login to answer
196 Like 38 Dislike
Previous forums Next forums
Other forums

help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "

Alternate messaging
I have 4 strings in MySQL db1

$string1 : Hello
$string2 : Hi
$string3 : Great

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

Find current logon time
in my sql script i want to query and find out the logon time of the current session.

If statement help please.
Hello on my site I have 2 content boxes. 1 is for the main content (which is the biggest one) and th

Session is not saving
I am not trying to do anything too fancy, I am just trying to get some $_SESSION data to save and us

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

Undefined variable: adHTML

While checking my site error logs, I've noticed one repetitive error that fills the lo

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS

Play Free Quiz and Win Cash