Skip to Content
0
Former Member
Apr 11, 2012 at 11:09 PM

HANA Procedure- Column Store Error.

464 Views

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.