Jasper Server / Studio Execute stored procedure with arguments


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 ...



elementsti's picture
Joined: Jul 16 2015 - 5:29am
Last seen: 7 years 10 months ago

0 Answers:

No answers yet