Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
<esql:execute-query>
<esql:call>
{? = 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:parameter 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>
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-----Original Message-----
From: Michael Raffenberg [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 7:25 PM
To: [EMAIL PROTECTED]
Subject: AW: esql:query problem
Hi Tim,
did you try the <esql:call> Tag?
Here you find a introduction:
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
--Raffy
> -----Urspr�ngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 23. Juni 2003 22:55
> An: [EMAIL PROTECTED]
> Betreff: esql:query problem
>
>
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
