Hi,
how can I call a stored procedure on a sybase ase db with arguments.
I'm able to execute a query with a stored procedure but with no arguments:
<queryString LANGUAGE="plsql"> <![CDATA[EXECUTE dbo.spumb_topXdestinations]]> </queryString>
But if I add an argument with a default value to the procedure it always takes the default value and without a default value jasper returns an sql execution error.
I tried it like this:
<queryString LANGUAGE="plsql"> <![CDATA[EXECUTE dbo.spumb_topXdestinations 5]]> </queryString>
Header stored procedure:
CREATE PROCEDURE dbo.spumb_topXdestinations @branchid INT AS BEGIN ...
Regards
Marco
0 Answers:
No answers yet