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




                                        execute a_joe







<esql:get-string column="1"/>












To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to