Jasper Server / Studio Execute stored procedure with arguments

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

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

0 Answers:

No answers yet
Feedback
randomness