stanlevin Posted November 6, 2006 Share Posted November 6, 2006 Hi, 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: com.sybase.jdbc2.jdbc.SybDriver Regards,Stan. Link to comment Share on other sites More sharing options...
patricksand Posted April 5, 2007 Share Posted April 5, 2007 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 typeexec <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 helpsPost edited by: patricksand, at: 2007/04/05 14:43 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now