Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using MS XMLHttp to post XML to PL/SQL or JSP

19751Oct 1 2001 — edited Oct 6 2004
I have been able to use the Microsoft XMLHttp object to post an
XML dom to an XSQL page and then do an xsql:insert-request with
the posted xml and return the results:

<script language=javascript>
//IE5 client side script
function saveXML()
{
var xmldoc = new ActiveXObject ("Microsoft.XMLDOM")
xmldoc.async = false
xmldoc.loadXML('<data>test</data>')
var xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
xmlhttp.Open("POST", "http://atlas/xsql/insert.xsql",
false);
xmlhttp.Send(xmldoc);
alert("This is the response: " + xmlhttp.responseText);
}
</script>

Can I do the same thing but post to a PL/SQL procedure through
mod_plsql:

xmlhttp.Open
("POST", "http://atlas/pls/scott/insert_proc", false);

using:

procedure insert_proc is
begin
-- ?? code to process the posted XML document ??

owa_util.mime_header('text/xml');
htp.p ('<?xml version="1.0" ?>');
htp.p ('<results>success</results>');

end;

How can I reference the posted XML in PL/SQL?

Is there any way to do this by posting to a JSP page?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2004
Added on Oct 1 2001
2 comments
472 views