On 30.Jul.2002 -- 10:44 AM, Frank Taffelt wrote:
> Hi,
>
> i'm trying to get an oracle stored procedure working, that returns a
> resultset.
> but i always get a :
>
> java.lang.RuntimeException: Error executing statement: { call ? :=
> sp_get_stocks(?) } : java.sql.SQLException: ORA-01008: not all variables
> bound
>
> here is my code:
>
> <esql:call resultset-from-object="1" needs-query="true">
> { call ? := sp_get_stocks(<esql:parameter direction="in"
> type="Int"><xsp:expr>20</xsp:expr></esql:parameter>) }
Try without the @resultset-from-object attribute, it serves a
different purpose. Try
<esql:call>{ sp_get_stocks(<esql:parameter direction="in"
type="Int"><xsp:expr>20</xsp:expr></esql:parameter>) }</esql:call>
I believe, oracle doesn't need @needs-query.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
