SAP S/4HANA Error 1327: Unsupported SQLScript Parameter Type

-- Example: If 'MY_UNSUPPORTED_TYPE' was used for a parameter, change it to VARCHAR or NVARCHAR.
CREATE PROCEDURE MY_PROCEDURE ( IN MY_SUPPORTED_PARAM VARCHAR(100) ) 
LANGUAGE SQLSCRIPT 
AS 
BEGIN 
  -- Procedure logic using MY_SUPPORTED_PARAM
END;

DATA: lv_param_value TYPE string.
DATA: lt_table_data TYPE STANDARD TABLE OF some_abap_structure.

" Populate lt_table_data

" Convert complex data to a format suitable for SQLScript, e.g., a string representation of a table or individual values.
" Example: If SQLScript expects a table of strings, convert your structure to that.
LOOP AT lt_table_data INTO DATA(ls_row).
  CONCATENATE lv_param_value ';' ls_row-field1 INTO lv_param_value SEPARATED BY space.
ENDLOOP.

" Call the SQLScript with the converted parameter
CALL FUNCTION 'MY_SQLSCRIPT_CALLER' 
  EXPORTING 
    iv_parameter = lv_param_value
  IMPORTING 
    ev_result    = DATA(lv_result).

" Note: This is a simplified example. The actual conversion logic will depend on the SQLScript's expected input.

CREATE TYPE MY_TABLE_TYPE AS TABLE ( 
  FIELD1 VARCHAR(100), 
  FIELD2 INTEGER, 
  FIELD3 DECIMAL(10,2) 
);

CREATE PROCEDURE MY_PROCEDURE_WITH_TABLE ( IN IT_DATA MY_TABLE_TYPE ) 
LANGUAGE SQLSCRIPT 
AS 
BEGIN 
  -- Procedure logic using IT_DATA
END;

TYPES: BEGIN OF ts_hana_data,
         field1 TYPE string,
         field2 TYPE i,
         field3 TYPE p DECIMALS 2,
       END OF ts_hana_data.
TYPES: tt_hana_data TYPE STANDARD TABLE OF ts_hana_data WITH EMPTY KEY.

DATA: lt_data TYPE tt_hana_data.

" Populate lt_data

CALL FUNCTION 'MY_SQLSCRIPT_CALLER' 
  EXPORTING 
    it_parameter = lt_data
  IMPORTING 
    ev_result    = DATA(lv_result).

" Note: 'MY_SQLSCRIPT_CALLER' would be a function module or method that wraps the CALL METHOD to the HANA procedure.