[
https://issues.jboss.org/browse/TEIIDDES-923?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-923:
---------------------------------------
Is this during "Preview Data" query? or Execute VDB or both?
Passing NULL into a Procedure in Preview Causes Exception
---------------------------------------------------------
Key: TEIIDDES-923
URL:
https://issues.jboss.org/browse/TEIIDDES-923
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 7.4
Reporter: Ted Jones
I have a virtual procedure that accepts one parameter that may be null. When I pass a
value in it works fine but when I check the NULL checkbox fir the input variable I get the
following exception, "Remote org.teiid.api.exception.query.QueryValidatorException:
Bind variables (represented as "?") were found but are allowed only in prepared
or callable statements."
Here is the generated query from preview: select * from ( exec RestfulBooks.getBooks(?) )
AS X_X
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira