Jump to content

elementsti

Members
  • Posts

    1
  • Joined

  • Last visited

elementsti's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. 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
×
×
  • Create New...