I am facing error when I am using select statement on a view generated while creating procedure.
drop procedure EMP_SEL;
create procedure EMP_SEL (IN EMP_CITY varchar2(30),OUT EMP EMPLOYEE)LANGUAGE
SQLSCRIPT READS SQL DATA WITH RESULT VIEW EmpView AS
EMP = select * from EMPLOYEES where EMPLOYEE_CITY = :EMP_CITY;
When I call the procedure using below statements I got result as expected.
call TCS252996.EMP_SEL('zurich',NULL)with overview;
select * from "TCS252996"."EMP_4F8333FD9B58C7CEE10000000A64628D";
when I use the below statement ,facing below error
SAP DBTech JDBC:  (at 26): column store error: search table error:  Internal error during instantiating calculation model
Request your expertise in identifying the problem .