SQL Server

AI Ask with Multiple Tool Function Callbacks

See more AI Examples

This example demonstrates asking a two-part question that should cause the AI to respond with two tool call requests. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  ----------------------------------------------------------------------------------
    --  The Javascript file loaded here is shown at the bottom of this page.
    --  -----------------------------------------------------------------------------------

    --  Load JavaScript containing the tool functions.
    DECLARE @sbJs int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbJs OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @sbJs, 'LoadFile', @success OUT, 'qa_data/js_tools/toolset_6.js', 'utf-8'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @sbJs, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbJs
        RETURN
      END

    DECLARE @ai int
    EXEC @hr = sp_OACreate 'Chilkat.Ai', @ai OUT

    --  Register the tools that will be made available to the AI.
    DECLARE @evalOnly int
    SELECT @evalOnly = 0
    DECLARE @allowAllKeyword int
    SELECT @allowAllKeyword = 1
    EXEC sp_OAMethod @ai, 'RegisterJsTools', @success OUT, @sbJs, @evalOnly, @allowAllKeyword

    --  The provider can be "openai", "google", "claude", "grok", "mistral", "custom", etc.
    EXEC sp_OASetProperty @ai, 'Provider', 'openai'
    --  Use your provider's API key.
    EXEC sp_OASetProperty @ai, 'ApiKey', 'MY_API_KEY'
    --  Choose a model.
    EXEC sp_OASetProperty @ai, 'Model', 'gpt-5.6-luna'

    --  Tool function calling must always occur within a conversation.
    DECLARE @conversation_name nvarchar(4000)
    SELECT @conversation_name = 'example_convo'
    DECLARE @sysMessage nvarchar(4000)
    SELECT @sysMessage = 'You are a helpful assistant'
    DECLARE @devMessage nvarchar(4000)
    SELECT @devMessage = 'Respond with markdown'
    EXEC sp_OAMethod @ai, 'NewConvo', @success OUT, @conversation_name, @sysMessage, @devMessage

    --  Provide inputs
    EXEC sp_OAMethod @ai, 'InputAddText', @success OUT, 'What is my horoscope? I am an Aquarius.  Also, what''s the weather in Chicago?'

    --  Send inputs, tool functions, etc. and ask for a "text" response.
    --  If the AI responds with tool calls, Chilkat automatically handles them by calling your JavaScript
    --  tool functions as directed by the AI, and sending results back to the AI until the final
    --  response is received.
    EXEC sp_OAMethod @ai, 'Ask', @success OUT, 'text'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ai, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbJs
        EXEC @hr = sp_OADestroy @ai
        RETURN
      END

    --  Get the AI response.
    DECLARE @sbResponse int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponse OUT

    EXEC sp_OAMethod @ai, 'GetOutputTextSb', @success OUT, @sbResponse
    EXEC sp_OAMethod @sbResponse, 'GetAsString', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @sbJs
    EXEC @hr = sp_OADestroy @ai
    EXEC @hr = sp_OADestroy @sbResponse


END
GO

JavaScript

// The namespace for the AI tool functions in this JavaScript source file.
Example = {};

// Tool functions must have only one argument, which should be an object.

// The function name used here must match the "name" in the toolRegistry below.
Example.get_weather = function(arg) {
  return {
	  "temperature": 45,
	  "unit": "F",
	  "conditions": "Cloudy"
	};
}

Example.get_horoscope = function(arg) {
  return  `${arg.sign} : Next Tuesday you will befriend a baby otter.`;
}



// The inputSchema.type must ALWAYS be "object".
Example.toolRegistry = [
  {
    name: "get_horoscope",
    description: "Get today's horoscope for an astrological sign.",
    parameters: {
      properties: {
        sign: { type: "string", description: "An astrological sign like Taurus or Aquarius" }
      }
    }
  },
  {
    name: "get_weather",
    description: "Gets the weather at a location.",
    parameters: {
      properties: {
        location: { type: "string", description: "Location such as a city name." },
      }
    }
  }
];


Example.toolPermissions = [
	  {
	    name: "all",
	    perm: "sandbox",
	  }
	  		
	];
	
	
// Return the name of this toolset
// This tells Chilkat the namespace of this toolset.
"Example";