cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: MSSQL Stored procedure & ESQL
Date Tue, 01 Oct 2002 07:29:46 GMT
On 30.Sep.2002 -- 06:07 PM, fcbc wrote:
> 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>

Please see your MS docs whether your call will return a ResultSet or
not. The syntax depends on that, see Apache Cocoon docs for details.

In addition, return parameters from CallableStatements are never
named. They are *only* accessible by number.

	Chris.

Please follow up summarizing your problem and which suggested solution
/ information worked for you when you consider your problem
solved. Add "SUMMARY: " to the subject line. This will make FAQ
generation and searching the list easier. In addition, it makes
helping you more fun. Thank you.

-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
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>


Mime
View raw message