Jump to content
Changes to the Jaspersoft community edition download ×

Calling Sybase Procedure in Reports Wizard


Recommended Posts



I am trying to use Reports Wizard to generate template for a Sybase data source. My query is a Stored Procedure with a single Parameter. This is what I put in the Wizard's SQL query:

exec test_proc $P{cif}


The Wizard generates an error:


SQL problem:

'$' is an invalid money value.


Does anyone know if it is possible at all to use a wizard for stored procedure with paremeter?



My driver settings:





Link to comment
Share on other sites

  • 4 months later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

What I found that works is the following:


1. use '$P!{<parameter>}' instead of $P{<parameter>} for strings and $P!{<parameter>} for non-strings...no clear documentation, but I found it searching the forum.


One word of caution: declare a default value for any parameter so that you can get definitions of any rows returned from the SP; even parameters associated with OUTPUT only SP arguments.


2. For non-parameter values, just


declare @var type

exec <stored_proc> @var


and use it in the normal way on a SP call


I'm not sure if you can set the variable to a value, but it works great for a return value...


Hope this helps

Post edited by: patricksand, at: 2007/04/05 14:43

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...