When you invoke the SelectAI process, Oracle generates an SQL query response or a natural language response based on the input provided.
1Open the SelectAI process and click Actions > Properties Details > Copy Service URL.
2Open 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.
3Open 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.