Jasper Server / Studio Execute stored procedure with arguments

[elementsti]

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>[/code]

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>[/code]

Header stored procedure:

CREATE PROCEDURE dbo.spumb_topXdestinations @branchid int AS BEGIN ...[/code]

 

Regards

Marco