Hello, I have followed all the steps in this blog:
https://blogs.oracle.com/apex/post/configuring-generative-ai-in-oracle-apex-using-select-ai
But when I run the last part
BEGIN
dbms\_output.put\_line(
dbms\_cloud\_ai.generate(
prompt => 'total tasks having status as closed ',
action => 'showsql',
profile\_name => 'OPENAI\_GPT'
)
);
END;
I get this error
ORA-20000: ORA-24247: Network access denied by access control list (ACL)
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240705_0", línea 2064
ORA-06512: en "C##CLOUD$SERVICE.DBMS_CLOUD_AI", línea 5674
ORA-06512: en línea 2 Error at Line: 7 Column: 0
I don't know how to continue and I don't see that from APEX I have visibility of the OPENAI_GPT profile.
Has anyone been able to complete it?
Thanks