When you invoke the SelectAI process, Oracle generates an SQL query response or a
natural language response based on the input provided.
Open the
SelectAI
process and click
Actions
Properties Details
Copy Service URL
.
Open a text editor and add the input fields and
values to the service URL as shown in the following format:
<Cloud
Application Integration POD
URL>/active-bpel/public/rt/<API_name>?prompt=<User_Prompt>&action=<action>&profile=<profile>
Here,
prompt
is the query to the Oracle Autonomous Database
in Natural Language.
action
is the type of action to be
performed on the query such as showsql, narrate, and chat. If you do not pass
any action input, the narrate action is used as the default action.
profile
is the database profile that is used to run
the query.
Open a browser and paste the service URL.
You can also invoke the process using the Run Using option, REST or SOAP API endpoints in any
API clients, such as cURL, Postman, SOAP UI, or through any programming language.