Hi All
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
BEGIN
EMP = select * from EMPLOYEES where EMPLOYEE_CITY = :EMP_CITY;
END;
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: [2048] (at 26): column store error: search table error: [34023] Internal error during instantiating calculation model
Request your expertise in identifying the problem .
Thanks
Santosh.