Hi,
I am using https://blogs.oracle.com/apex/post/configuring-generative-ai-in-oracle-apex-using-select-ai for creating AI profile in the last step.
When i create a profile using cohere then i get below error. please help me with it.
BEGIN
DBMS_CLOUD_AI.CREATE_PROFILE(
profile_name => 'COHERE_LLM',
attributes => '{ "provider": "cohere",
"credential_name": "COHERE_CRED",
"object_list": [{"owner": "STLEARN", "name": "PROJECT_TASKS"}]
}',
description => 'AI profile to use Cohere for SQL translation'
);
END;
ORA-04063: package body "C##CLOUD$SERVICE.DBMS_CLOUD_AI" has errors ORA-06508: PL/SQL: could not find program unit being called: "C##CLOUD$SERVICE.DBMS_CLOUD_AI" ORA-06512: at line 2 Error at Line: 7 Column: 0