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>) }
</esql:call>
<esql:call-results>
<esql:row-results>
<result><esql:get-string column="1"/></results>
</esql:row-results>
</esql:call-results>
am I doing something stupid here or can somebody give me an working example
of an oracle procedure that returns
a resultset.
thanks,
Frank
---------------------------------------------------------------------
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]>
