oracle 23ai通过接口访问deepseek模型

来源:这里教程网 时间:2026-03-03 22:17:27 作者:

oracle 23ai可以通过外部ai模型接口访问ai并获取数据结果 ,使用步骤如下: 注册账号后,申请创建一个 API 密钥 密钥导入数据库 declare   jo json_object_t; begin   jo := json_object_t();   jo.put('access_token', 'sk-xqwxfym *********************** zcvnnbz');   dbms_vector.create_credential(credential_name => 'COHERE_CRED',                                 params          => json(jo.to_string)); end; / 配置 访问 deepseek ACL BEGIN   DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(     host => 'api.siliconflow.cn',     ace => xs$ace_type(privilege_list => xs$name_list('http'),                        principal_name => 'test',                        principal_type => xs_acl.ptype_db)   ); END; / 字符集设置 exec utl_http.set_body_charset('UTF-8'); 调用模型查询 select DBMS_VECTOR_CHAIN.UTL_TO_GENERATE_TEXT('杭州景点',json('{"provider":"openai","credential_name": "COHERE_CRED","url": "https://api.siliconflow.cn/v1/chat/completions","model":"THUDM/glm-4-9b-chat"}'));

相关推荐