I am attempting to call a stored procedure using esql:query. Other
stored procedures work using this so it is not a connection issue. I
have narrowed down the issue to being the procedure itself. I am
selecting data and inserting it into a temp table then selecting more
data and joining the two data sets. I need to use the temp tables there
is no way around it. The problem is the stored procedure will not
return a result set in cocoon because it sees the insert statement then
stops thinking there is not a result set. My code from my xsp is below,
if anyone has any information about why this does not work it would be
greatly appreciated. Thank you
Tim Bachta
<esql:execute-query>
<esql:query>
execute a_joe
'<xsp:expr>room</xsp:expr>','<xsp:expr>beginTime</xsp:expr>','<xsp:expr>
endTime</xsp:expr>'
</esql:query>
<esql:results>
<task-dates>
<esql:row-results>
<task-date>
<date>
<esql:get-string column="1"/>
</date>
</task-date>
</esql:row-results>
</task-dates>
</esql:results>
</esql:execute-query>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
