Suppressing request preprocessor error

drumcircle
Rising Star


CREATE OR REPLACE LUA SCRIPT "MYSCHEMA"."MYFILTER" () RETURNS ROWCOUNT AS
import('SCRIPTS.FILTER_01', 'pp')
local error_msg = pp.process_request(sqlparsing)
-- don't want to return result set if there are errors, show error msg
if string.len(error_msg)>0 then
output("Error")
-- system throws 43100 error here
error(error_msg)
end

[Code: 0, SQL State: 43100] While preprocessing SQL with "MYSCHEMA"."MYFILTER": 43000:"Suppressing request" caught in script "MYSCHEMA"."MYFILTER" at line 6 (Session: 1707103985739038720)

1 REPLY 1

mwellbro
Xpert

Hi @drumcircle ,

I´m not exactly sure if this is a question or a "how to" - could you give a few more lines as to how this post is intended ?
From what I can tell, this piece of code errors out with the "Suppressing request" message which probably was set in
your SCRIPTS.FILTER_01 script - soooo, works as intended ?

Cheers,
Malte