ok second try with:
<esql:call>
{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>
<out><esql:get-string column="1"/></out>
</esql:row-results>
</esql:call-results>
results in :
Error executing statement: {call sp_get_stocks(?) }: java.sql.SQLException:
ORA-06550: line 1, column 7:
PLS-00221: 'SP_GET_STOCKS' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
this error message is confusing, because i have written a small java-jdbc
applicaion which calls this procedure
and receives a resultset from it.
any hints ?
---------------------------------------------------------------------
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]>
