Skip to Content
0
Apr 30, 2018 at 02:01 PM

Error in scripted calculation view

544 Views

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.