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?
Calling Sybase Procedure in Reports Wizard
in Products
Posted
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.