I use setting same as in SOA-3478. But I deleted the procedure from xmi files in the VDB (attachment) and changed query to:

String query = "{ CALL getEmployeeSurnames }";

The Query is called and result set is returned.

After conversation with Steven Hawkins I understand that this shouldn't be possible and Teiid should respond that it cannot resolve the query.