Skip to Content
0
Former Member
Jan 30, 2014 at 05:13 PM

Repository: Encountered an error in repository runtime extension;error preparing statement create procedure "_SYS_BIC"."pack1.yathams/PRO_ARTI" ( in ARTID INTEGER , out ARTICLE_COLOOK "_SYS_BIC"."pack1.yathams/PRO_ARTI/tabletype/ARTICLE_COLOO

21 Views

Hi Friend,

When am trying to create a procedure under content the following error is occurred. Please let me know. What the error is.

I got the following error:

Repository: Encountered an error in repository runtime extension;error preparing statement create procedure "_SYS_BIC"."pack1.yathams/PRO_ARTI" ( in ARTID INTEGER , out ARTICLE_COLOOK "_SYS_BIC"."pack1.yathams/PRO_ARTI/tabletype/ARTICLE_COLOOK" ) language SQLSCRIPT sql security definer reads sql data as n /********* Begin Procedure Script ************/ nBEGINnnOUT1 = CE_COLUMN_TABLE("YATHAMS"."ARTICLE_COLOR_LOOKUP",["ARTICLE_ID","COLOR_CODE","CATEGORY"]);nnOUT2 = CE_COLUMN_TABLE("YATHAMS"."ARTICLE_LOOKUP",["ARTICLE_ID","SALE_PRICE","FAMILY_NAME","FAMILY_CODE"]);nnOUT3 = CE_JOIN(:OUT1,:OUT2,["ARTICLE_ID"]);nnnOPT = CE_PROJECTION(:OUT3,["ARTICLE_ID","COLOR_CODE","CATEGORY","SALE_PRICE","FAMILY_NAME","FAMILY_CODE"]);nEND;n /********* End Procedure Script ************/ for oid {tenant: , package: pack1.yathams, name: PRO_ARTI, suffix: procedure}: some out table var is not assigned: ARTICLE_COLOOK at ptime/query/checker/proc_check.cc:99

This is my procedure:

BEGIN

OUT1 = CE_COLUMN_TABLE("YATHAMS"."ARTICLE_COLOR_LOOKUP",["ARTICLE_ID","COLOR_CODE","CATEGORY"]);

OUT2 = CE_COLUMN_TABLE("YATHAMS"."ARTICLE_LOOKUP",["ARTICLE_ID","SALE_PRICE","FAMILY_NAME","FAMILY_CODE"]);

OUT3 = CE_JOIN(:OUT1,:OUT2,["ARTICLE_ID"]);

OPT = CE_PROJECTION(:OUT3,["ARTICLE_ID","COLOR_CODE","CATEGORY","SALE_PRICE","FAMILY_NAME","FAMILY_CODE"]);

END;

Thanks & Regards,

Sreenivas