| Stored procedure parameters [message #76640] |
Thu, 22 September 2005 13:03 |
Eclipse User |
|
|
|
Originally posted by: mshaw.tesco.net
Hi All,
How do I call a stored procedure with parameters?
I have a procedure that meets the criteria from Linda Chan's message and
works when I call it with hard coded strings for the parameters.
However, when I replace the string with a ? and add a parameter with a
default value equal to the original hard coded value I get an incorrect
syntax exception.
It works with this in the query pane:
proc_IVR_DAILY_DETAIL_REPORT '2005-08-02', '2005-10-01'
but throws the exception when I do
proc_IVR_DAILY_DETAIL_REPORT ?, '2005-10-01'
Any idea what I've done wrong?
Regards,
Marcus Shaw.
P.S. Thanks to all the BIRT development team. BIRT came out just when
I needed it!
|
|
|
Powered by
FUDForum. Page generated in 0.02928 seconds
Home