使用原生SQL执行动态参数，SQL会报错，提示@错误，只能写字符串类型的sql。

    将变量替换掉

    1. select BASEID,SCCODE,JSON,LASTDATE from ENTERPRISEPUBDB.{pair.Value} where BASEID = '{baseId}'
    1. // orcale 语法 参数使用 冒号（:）
    2. // 全文索引
    3. res = _freeSql.Ado.Query<DmBizBaseInfo>
    5. (@"select ""Id"",""SCCode"",""EntName"",""LegRep"",""EntBigType"",""EntType"",""EstDate"",""Addr"",""Status"",""ValidDate"",""ValidCode"",""LastDate"" from 
    6. ENTERPRISEDB.""Biz_Base_Info"" where CONTAINS(""EntName"", :keyword) limit 50", 
    7.  new { keyword = entNameOrSCCode });

    image.png

    DM管理工具
    image.png

    1. -- 删除全文索引
    2. DROP CONTEXT INDEX IF EXISTS ENTNAME_IDX ON ENTERPRISEDB."Biz_Base_Info";
    4. -- 中文最少分词 CHINESE_LEXER （效率），机械双分词 CHINESE_VGRAM_LEXER（准确度）
    5. CREATE CONTEXT INDEX ENTNAME_IDX ON ENTERPRISEDB."Biz_Base_Info"("EntName") LEXER
    6. CHINESE_LEXER
    7. -- 指定为SYNC TRANSACTION时，每次事务提交后，若基表数据发生变化，系统会自动以增量更新方式填充全文索引；
    8. SYNC TRANSACTION;
    9. -- 查询样例
    10. select "Id","SCCode","EntName",
    11. "LegRep","EntBigType","EntType","EstDate",
    12. "Addr","Status","ValidDate","ValidCode",
    13. "LastDate" from ENTERPRISEDB."Biz_Base_Info" 
    14.     where CONTAINS("EntName", '书屋') limit 50;

    样例代码，发送http请求，通知程序

    1. dbms_output.enable; 
    3. 建立存储过程
    4. /***Manager***/CREATE PROCEDURE "ENTERPRISEPUBDB"."testhttp"
    5. AS
    6. req utl_http.REQ;
    7. resp utl_http.resp;
    8. data varchar2(32563);
    9. receiveDate varchar;
    10. BEGIN
    11. req :=
    12. utl_http.begin_request('http://10.0.11.102/', 'GET');
    13. data := '';
    14. utl_http.write_text(req, data);
    15. resp := utl_http.get_response(req);
    16. utl_http.set_body_charset(resp, 'utf-8');
    17. utl_http.read_text(resp, receiveDate, 1024);
    18. dbms_output.put_line(receiveDate);
    19. utl_http.end_response(resp);
    20. END;