I'd like to use an Oracle stored procedure for users to sign in. I have the
following code in my XSP:
<esql:execute-query>
<esql:call>{call pwdp.syusracc.encode_login(<esql:parameter direction="in"
type="String">username</esql:parameter>, <esql:parameter direction="in"
type="String">password</esql:parameter>, <esql:parameter direction="out"
type="Int"/>, <esql:parameter direction="out" type="String"/>,
<esql:parameter direction="out" type="String"/>)}</esql:call>
<esql:call-results>
<p>EmployeeMasterID is <esql:get-int column="3" from-call="true"/>.<br/>
Error code is <esql:get-string column="4" from-call="true"/>.</p>
</esql:call-results>
</esql:execute-query>
The employee ID in column 3 is coming back fine, but when the generator gets
to the <esql:get-string> element for column 4, I get the following error:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():
org.apache.avalon.framework.CascadingRuntimeException: Error getting ascii
data for colum 4
Any ideas? I'm sure that the stored procedure is set up to return a string
as the fourth column. I've tried many combinations of esql get elements and
parameter types. I'm using Cocoon 2.0.4 on Tomcat 4.1.12.
Thanks!
J
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
