Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> XSQLServlet - simple question
Hi all,
I would like to select a row in a single table using the XSQLServlet
from Oracle (verison 10.1.0.2)
My table is :
CREATE TABLE MAPPING (
context VARCHAR2(255) NOT NULL, key VARCHAR2(255) NOT NULL, value VARCHAR2(255),
ALTER TABLE MAPPING ADD CONSTRAINT PK_mapping
PRIMARY KEY (context, key);
I just would like to execute this query : SELECT VALUE AS VALUE FROM MAPPING WHERE CONTEXT = ? and KEY = ?
If I pass the parameters in the url (GET method) it works fine. But I
need to use the POST method.
I post an XML like that :
<?xml version="1.0" encoding="ISO-8859-1"?>
<request>
<parameters>
<context>TEST_CONTEXT</context>
<key>TEXT_KEY</key>
</parameters>
</request>
How can I retreive both CONTEXT and KEY parameters from the posted XML ?
Thanks in advance for your help. Received on Mon May 29 2006 - 10:26:40 CDT