javascript - 雪花程序迁移

Question

有人可以帮我指导一下，这是通过 JS 将 oracle 程序转换为雪花的最佳方式。

甲骨文过程：

PROCEDURE ABC（LOGGED_USER IN VARCHAR，request_date IN VARCHAR，页面 IN VARCHAR，活动 IN VARCHAR，payload_request IN VARCHAR，CHANGED_USER IN VARCHAR）开始插入 ABCD（LOGGED_USER，request_date，页面，活动，payload_request，CHANGED_USER）值（LOGGED_USER，TO_DATE (request_date, 'MM/DD/YYYY HH24:MI:SS'), 页面, 活动, payload_request, CHANGED_USER); 当其他人插入 ABCD 时例外（LOGGED_USER，request_date，page，activity，payload_request，CHANGED_USER） 值（LOGGED_USER，''，page，activity，payload_request，CHANGED_USER）；结束ABC；

雪花过程

创建或替换过程 xxxxx (LOGGED_USER STRING, REQUEST_DATE STRING, PAGE STRING, ACTIVITY STRING, PAYLOAD_REQUEST STRING, CHANGED_USER STRING) 语言 javascript as $ $ try { var query = "INSERT INTO ABC (LOGGED_USER, REQUEST_DATE, PAGE, ACTIVITY, PAYLOAD_REQUEST, CHANGED_USER ) 值 ({$LOGGED_USER}, TO_DATE ({$REQUEST_DATE}, 'MM/DD/YYYY HH24:MI:SS'), {$PAGE}, {$ACTIVITY}, {$PAYLOAD_REQUEST}, {$CHANGED_USER}); " var sql = snowflake.createStatement({ sqlText: query }); var 结果 = sql.execute(); } catch(error) { var query = "INSERT INTO ABC (LOGGED_USER, REQUEST_DATE, PAGE, ACTIVITY, PAYLOAD_REQUEST, CHANGED_USER) 值 ({$LOGGED_USER}, 'NULL', {$PAGE}, {$ACTIVITY}, {$PAYLOAD_REQUEST }, {$CHANGED_USER});" var sql = snowflake.createStatement({ sqlText: query }); var 结果 = sql.execute(); 返回错误。信息; } $$;

谢谢，尼基尔

标签： javascriptstored-proceduressnowflake-cloud-data-platform