SQL Server

Automatic JS AI Tool Calling with Supporting JS Sources

See more AI Examples

Demonstrates an automatic JavaScript tool function calling where JavaScript code can be loaded from additional scripts that don't include a tool registry. 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
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

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

    -- In this example, we'll load the Javascript tool functions and registry from a file.
    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_5.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

    -- Additional JavaScript code can be loaded into the AI object's internal JS engine
    -- by calling RegisterJsTools with evalOnly = 1.
    DECLARE @sbExtraJs int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbExtraJs OUT

    EXEC sp_OAMethod @sbExtraJs, 'Append', @success OUT, 'function getOrderTotal({ order_id }) { return 149.95; }'

    -- When evalOnly equals 1, it tells Chilkat that no toolRegistry will be present.
    -- The purpose for doing the eval is to add function definitions to the global namespace.
    -- The value passed for allowAllKeyword is meaningless (not used) when evalOnly = 1.
    DECLARE @evalOnly int
    SELECT @evalOnly = 1
    DECLARE @allowAllKeyword int
    SELECT @allowAllKeyword = 1
    EXEC sp_OAMethod @ai, 'RegisterJsTools', @success OUT, @sbExtraJs, @evalOnly, @allowAllKeyword

    -- Register the tools that will be made available to the AI.
    SELECT @evalOnly = 0
    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-mini'

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

    -- Provide inputs
    EXEC sp_OAMethod @ai, 'InputAddText', @success OUT, 'What is the total for order A123?'

    -- 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
        EXEC @hr = sp_OADestroy @sbExtraJs
        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 @sbExtraJs
    EXEC @hr = sp_OADestroy @sbResponse


END
GO