Order of params for stored procedures
I am trying to use the JDBC driver for using published queries. Everything works fine on queries with one or two params. But when there are multiple params, I can't seem to get back any results.
Do you have examples on how best to handle multiple parameters for a query of different types?
Do you have examples on how best to handle multiple parameters for a query of different types?
- sbagaria
- Community Advisory Board Member
- Posts: 92
- Joined: Thu Jul 05, 2012 9:23 pm
OK. Got some hints. I have to skip the quote characters. They are considered a part of the string. The order is what appears in the wsECL interface or the columns information for the procedure.
Now the only remaining question is how do I either skip a parameter so that the default value is taken from the ECL code or input an empty string as the param?
Now the only remaining question is how do I either skip a parameter so that the default value is taken from the ECL code or input an empty string as the param?
- sbagaria
- Community Advisory Board Member
- Posts: 92
- Joined: Thu Jul 05, 2012 9:23 pm
The driver doesn't currently allow mismatching stored procedure signatures (it rejects the request if the number of in params don't match.)
Let me know if this is an issue for you, we can discuss a change request if it makes sense. Thanks, Rodrigo.
Let me know if this is an issue for you, we can discuss a change request if it makes sense. Thanks, Rodrigo.
- [email protected]
- Posts: 22
- Joined: Fri Oct 07, 2011 2:24 pm
Thanks! It's not critical. I had some logic defined for empty strings. I now changed it to an '_'.
- sbagaria
- Community Advisory Board Member
- Posts: 92
- Joined: Thu Jul 05, 2012 9:23 pm
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest