Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
<http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport> and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
<esql:execute-query>
<esql:call>
{? = rptLocationDeviations(<esql:parameter direction="in"
type="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}
</esql:call>
<esql:call-results>
<esql:use-results>
<esql:result>
<xsp:expr>
<esql:get-object
column="1" from-call="true"/>
</xsp:expr>
</esql:result>
<esql:results>
<esql:row-results>
<test>
<esql:get-string column="1"/>
</test>
</esql:row-results>
</esql:results>
</esql:use-results>
</esql:call-results>
</esql:execute-query>
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
Tim Bachta
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
