Skip to Content
0
Former Member
Oct 30, 2016 at 03:11 PM

SQL Script Numeric For Loop

94 Views Last edit Nov 02, 2016 at 04:57 AM 2 rev

Getting error - Cannot create catalog object:invalid identifier

I have written the following code but keep getting the above error and don't know where is the issue. Could you please assist to correct this code.

PROCEDURE"GARGM"."mgarg::IS_SKIPCOL"(INcolumnname VARCHAR, OUT v_result BOOLEAN )

LANGUAGESQLSCRIPT

AS

i INTEGER := 0;

BEGIN

/*****************************

Write your procedure logic

*****************************/

lt_skipcol = SELECT* FROM "GARGM"."mgarg::GLOBAL.lst_col" ;

FOR i IN lt_skipcol.First .. lt_skipcol.Last

DO

END FOR;

END;