custom table type in stored procedure sap hana
<p>I'm new in the sap hana world. I'm trying to use stored procedures to update info. I want to send a custom table type with the field name, field value and row id.
I created this type:</p>

<pre><code>CREATE TYPE t_field AS TABLE (
   ID INTEGER,
   FLD VARCHAR(100),
   VAL VARCHAR(100));
</code></pre>

<p>And I used it in this procedure:</p>

<pre><code>    PROCEDURE "_SYS_BIC"."Match.procedures::updateAnag" (
    in tfield tt_field,
    out error tt_error
 ) 

 LANGUAGE SQLSCRIPT
 SQL SECURITY INVOKER 
 DEFAULT SCHEMA "_SYS_BIC"
 AS

BEGIN

     declare _id integer; 
     declare _field varchar(100);
     declare _value varchar(100);

     select ID, F_NAME, F_VALUE
     into _id, _field, _value
     from :tfield;

    IF(_field = '' OR _value = '') THEN
        error = SELECT 400 AS http_status_code,
                 'empty field' as error_message,
                  'All fields must be filled' as detail from dummy;
    ELSE

    IF (_field = 'name') THEN
        UPDATE "_SYS_BIC"."TEST_TABLE" 
        SET NAME = _value
        WHERE ID = _id;
    END IF;

    IF (_field = 'surname') THEN
        UPDATE "_SYS_BIC"."TEST_TABLE" 
        SET SURNAME = _value
        WHERE ID = _id;
    END IF;

    END IF;

END; 
</code></pre>

<p>But when I try to activate the code, eclipse returns me this error:
'sap-ui-core.js:159 2016-07-19 17:45:47.751550 The following problem occurred: HTTP request failed400,Bad Request,Request contains properties that do not exist in entity &#x0027;anagType&#x0027;. -'</p>

<p>Can someone help me to fix it or show me a better way to do this?</p>