[prev in list] [next in list] [prev in thread] [next in thread] 

List:       xml-cocoon-users
Subject:    MSSQL Stored procedure & ESQL
From:       fcbc <fcbc () donetsk ! fc ! kiev ! ua>
Date:       2002-09-30 16:07:40
[Download RAW message or body]

I'm trying to get a result set from stored proc but it ends with error:
org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): \
java.lang.RuntimeException: Error getting clob data: null

the code snippet:
<esql:connection>
<esql:pool>sqlserver</esql:pool>
<esql:execute-query>
<esql:call>
{? = call Rp_OperDocs(<esql:parameter type="int" direction="in">
<xsp:expr>37521</xsp:expr>
</esql:parameter>)}
</esql:call>
<esql:call-results>
<esql:row-results>
<esql:get-string column="Kind"/>
</esql:row-results>
</esql:call-results>
</esql:execute-query>
</esql:connection>

What wrong? Help please.


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


[prev in list] [next in list] [prev in thread] [next in thread]