Hi,
I'm trying to use a stored procedure for making an update in an Oracle database.
Here is the xsp+esql code:
<?xml version="1.0" encoding="iso-8859-1"?>
<xsp:page
language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<xsp:structure>
<xsp:include>java.lang.String</xsp:include>
</xsp:structure>
<update>
<esql:connection>
<esql:pool>sca</esql:pool>
<xsp:logic>
String app_id = request.getParameter("app_id");
String user_id = request.getParameter("user_id");
if (app_id != null || user_id != null) {
<esql:call>
You are at least missing a <esql:execute-query> tag surrounding the <esql:call/>
HTH
Chris.--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
