Never mind. Evidently get-boolean works. J
-----Original Message----- From: Jacob Arnold [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:16 AM To: '[EMAIL PROTECTED]' Subject: Stored Procedure Question 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]> --------------------------------------------------------------------- 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]>
