3.2 CHAT Function Signature 1

This function chats with a Generative AI service given a prompt and potential earlier responses.

Syntax

APEX_AI.CHAT (
    p_agent_static_id   IN              VARCHAR2,
    p_prompt            IN              CLOB,
    p_messages          IN OUT NOCOPY   t_chat_messages )
    RETURN CLOB;

Parameters

Parameter	Description
p_agent_static_id	The static ID of the AI Agent defined under the application's Shared Components.
p_prompt	The user prompt.
p_messages	The responses from an earlier conversation. Responses are automatically added to p_messages for an easy conversational experience.

Returns

The response for the given prompt.

Example

The following example chats with the assistant configured as my-oracle-assistant. In the first interaction, a system prompt is given. In later interactions, the context is passed to the generative AI service in the form of parameter p_messages.

DECLARE
  l_messages  apex_ai.t_chat_messages := apex_ai.c_chat_messages;
  l_response1 clob;
  l_response2 clob;
BEGIN
  l_response1 := apex_ai.chat(
    p_agent_static_id   => 'my-oracle-assistant',
    p_prompt            => 'What is Oracle APEX',
    p_messages          => l_messages );
  l_response2 := apex_ai.chat(
    p_agent_static_id   => 'my-oracle-assistant',
    p_prompt            => 'What is new in the latest release',
    p_messages          => l_messages );
END;