AI Services

Hi,

I'm trying to setup the APEX assistant with cohere, here are the steps I've done :

1. Create Generative AI Service

I successfuly tested the API key I used to create the service with Postman.

2. Granting ACL to api.cohere.ai to DB schema

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
	host => 'api.cohere.ai',
	ace => xs$ace_type(
	privilege_list => xs$name_list('connect','resolve'),
	principal_name => 'MY_SCHEMA',
	principal_type => xs_acl.ptype_db));
END;
/

3. Grant ACL to api.cohere.ai to APEX schema

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
	host => 'api.cohere.ai',
	ace => xs$ace_type(
	privilege_list => xs$name_list('connect'),
	principal_name => 'APEX_240100',
	principal_type => xs_acl.ptype_db));
END;
/

4. Add https://api.cohere.ai certificates to DB wallet

I've added all 3 certificates :

• Leaf
• Intermediate
• Root

5. Give DB schema access to wallet

Here the wallet path I used is the one in the Instance Settings.

BEGIN
dbms_network_acl_admin.append_wallet_ace(
	wallet_path => 'wallet_path',
	ace => xs$ace_type(privilege_list => xs$name_list('use_client_certificates', 'use_passwords'),
	principal_name => 'MY_SCHEMA',
	principal_type => xs_acl.ptype_db));
END;
/

After all that when trying to use the APEX assistant while debugging my session I have this error :

Exception in "begin_request":
Error Stack: ORA-29273: HTTP request failed
ORA-29259: end-of-input reached
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
Backtrace: ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 579

And when trying to call a basic URL with apex_web_service.make_rest_request I have the same error :

DECLARE
l_response CLOB;
BEGIN
	l_response := apex_web_service.make_rest_request(
	p_url => 'https://api.cohere.ai/v1/models',
	p_http_method => 'GET',
	p_credential_static_id => 'credentials_for_cohere_service');

DBMS_OUTPUT.PUT_LINE(l_response);
END;

DECLARE
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES", line 664
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 982
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 631
ORA-29259: end-of-input reached
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 579
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 795
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 1310
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES", line 624
ORA-06512: at "APEX_240100.WWV_FLOW_WEBSERVICES_API", line 661
ORA-06512: at line 4

That's the first time I setup a Genrative AI so I may have missed a step, but I can't find anything in existing forum discussions.

Appreciate any comment.