Hi Experts
Below is my code
/********* Begin Procedure Script ************/
BEGIN
var_out = CE_COLUMN_TABLE("SAPABAP1"."STXL",
[ "SRTF2" ,
"CLUSTR",
"TDNAME",
CONVERT ("CLUSTD" USING utf8) AS "CONVERTED_TEXT" ]);
END /********* End Procedure Script ************/
I am trying to decode the value stored in table - STXL,field- CLUSTD but i am experiencing the following error
Message : Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "USING": line 9 col 32 (at pos 422) Set Schema DDL statement: set schema "SYSTEM" Type DDL: create type "_SYS_BIC"."TEST/CLV_SCRIPTED_CONVERT_TEXT/proc/tabletype/VAR_OUT" as table ("SRTF2" SMALLINT, "CLUSTR" SMALLINT, "TDNAME" NVARCHAR(70), "CLUSTD" BLOB) Procedure DDL: create procedure "_SYS_BIC"."TEST/CLV_SCRIPTED_CONVERT_TEXT/proc" ( OUT var_out "_SYS_BIC"."TEST/CLV_SCRIPTED_CONVERT_TEXT/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as /********* Begin Procedure Script ************/ BEGIN var_out = CE_COLUMN_TABLE("SAPABAP1"."STXL", [ "SRTF2" , "CLUSTR", "TDNAME", CONVERT ("CLUSTD" USING utf8) AS "CONVERTED_TEXT" ]); END /********* End Procedure Script ************/
Please help me in this.