场景：需要js调用写好的存储过程

截图如下：
在这里插入图片描述

代码如下：

text
1 2 3 4 5 
var exe = "call insert_to_industry_lock("+parentId+","+"'"+date+"'"+","+week+","+"'"+creator+"'"+")";
var sql = 'SQL("数据集名称","'+exe+'",1,1)';
alert(exe);
return FR.remoteEvaluate(sql);

原文地址：https://blog.csdn.net/Shiny_boy_/article/details/128527674?ops_request_misc%3D%25257B%252522request%25255Fid%252522%25253A%252522168967555216800192234079%252522%25252C%252522scm%252522%25253A%25252220140713.130102334.pc%25255Fall.%252522%25257D%26request_id%3D168967555216800192234079%26biz_id%3D0%26utm_medium%3Ddistribute.pc_search_result.none-task-blog-2%7Eall%7Efirst_rank_ecpm_v1%7Erank_v31_ecpm-8-128527674-null-null.142%5Ev89%5Econtrol%2C239%5Ev2%5Einsert_chatgpt%26utm_term%3Dfinareportjs%25E8%25B0%2583%25E7%2594%25A8%25E5%25AD%2598%25E5%2582%25A8