Natural Language Interaction with Oracle Select AI

Back Next

Prerequisites

To use the Natural Language Interaction with Oracle Select AI recipe, the following prerequisites must be met:

Copy the

ojdbc8.jar

file to the following directory and restart the Secure Agent:

<Secure Agent installation directory>/apps/process-engine/ext

You can download the

ojdbc8.jar

file from the Oracle website.

Add the IP address of the Secure Agent machine to the ACL filtering exception list on the Oracle Cloud Server.

CREATE_CREDENTIAL procedure in the DBMS_CLOUD package.

DBMS_CLOUD.CREATE_CREDENTIAL (
credential_name IN VARCHAR2,
user_ocid       IN VARCHAR2,
tenancy_ocid    IN VARCHAR2,
private_key     IN VARCHAR2,
fingerprint     IN VARCHAR2);

The following table describes the parameters used for the create credential procedure:

Parameter	Description
credential_name	Specifies the name of the credential to be stored.
user_ocid	Specifies the user's Oracle client ID (OCID).
tenancy_ocid	Specifies the tenancy's OCID.
private_key	Specifies the generated private key. Private keys generated with a passphrase are not supported. You need to generate a private key without a passphrase.
fingerprint	Specifies a fingerprint. After a generated public key is uploaded to the user's account, the fingerprint is displayed in the console. Use the displayed fingerprint for this parameter.

For information about creating the credential procedure, see the Oracle DBMS Cloud documentation.

CREATE_PROFILE procedure in the DBMS_CLOUD_AI package.

DBMS_CLOUD_AI.CREATE_PROFILE
   profile_name        IN  VARCHAR2,
   attributes          IN  CLOB      DEFAULT NULL,
   status              IN  VARCHAR2  DEFAULT NULL,
   description         IN  CLOB      DEFAULT NULL
);

The following table describes the parameters used for the create profile procedure:

Parameter	Description
profile_name	Name of the AI profile. The profile name must follow the naming rules of the Oracle SQL identifier. The profile name can't exceed 125 characters. This is a required parameter.
attributes	Profile attributes in the JSON format. The default value is NULL .
status	Status of the profile. The default value is enable .
description	Description for the AI profile. The default value is NULL .

When you create a profile, you can associate the profile with the database tables. When the user prompts a query, Oracle runs that prompt in context with these tables to respond.

For more information about creating the profile procedure, see the Oracle DBMS Cloud AI package documentation.

After configuring the CREATE_CREDENTIAL procedure and CREATE_PROFILE procedure, you must perform the following steps:

Configure Select AI for Natural Language Interaction with your Database

Configure GENERATE function

Introduction to Natural Language Interaction with Oracle Select AI recipe

Download Guide

Watch

Comments

Cloud Application Integration Homepage

Free Trial

Communities

Knowledge Base