製品の説明：https://www.united-codes.com/products/uc-ai/docs/
% git clone -b main https://github.com/United-Codes/uc_ai.git
Cloning into 'uc_ai'...
remote: Enumerating objects: 2923, done.
remote: Counting objects: 100% (641/641), done.
remote: Compressing objects: 100% (437/437), done.
remote: Total 2923 (delta 329), reused 339 (delta 185), pack-reused 2282 (from 1)
Receiving objects: 100% (2923/2923), 6.37 MiB | 6.98 MiB/s, done.
Resolving deltas: 100% (1922/1922), done.
% cd uc_ai
uc_ai %
sql -name local-26ai-sys
grant create any context to apexdev;
uc_ai % sql -name local-26ai-sys
SQLcl: 月 4月 20 14:21:44 2026のリリース25.4 Production
Copyright (c) 1982, 2026, Oracle. All rights reserved.
接続先:
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
SQL> grant create any context to apexdev;
Grantが正常に実行されました。
SQL> exit
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0から切断されました
uc_ai %
uc_ai % sql -name local-26ai-apexdev
SQLcl: 月 4月 20 16:48:18 2026のリリース25.4 Production
Copyright (c) 1982, 2026, Oracle. All rights reserved.
接続先:
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0
SQL> @install_with_logger
Installing UC AI with logger
_____________________________________________________________________________
User has all required privileges, installation will continue.
_____________________________________________________________________________
PL/SQLプロシージャが正常に完了しました。
tables/logger_logs.sql
PL/SQLプロシージャが正常に完了しました。
PL/SQLプロシージャが正常に完了しました。
tables/logger_prefs.sql
PL/SQLプロシージャが正常に完了しました。
Trigger BIU_LOGGER_PREFSがコンパイルされました
[中略]
Package Body UC_AI_RESPONSES_APIがコンパイルされました
- Installing core UC AI package body...
Package Body UC_AIがコンパイルされました
Running post-installation scripts...
Logger package detected. Setting USE_LOGGER flag to TRUE.
Successfully compiled uc_ai_logger package with USE_LOGGER flag.
PL/SQLプロシージャが正常に完了しました。
===================================================
UC AI installation complete!
Refer to the documentation for usage instructions: https://www.united-codes.com/products/uc-ai/docs/
===================================================
Installation Complete!
SQL> exit
Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free
Version 23.26.1.0.0から切断されました
uc_ai %
アプリケーション・ビルダーを開き、インポートを実行します。
インポートするファイルとして、uc_ai/examples/sample-apps/practical-ai-made-easy以下のf135.sqlを選択します。同じディレクトリにpame_pkg.pks、pame_pkg.pkbやtables.sqlといったスクリプトがありますが、これらはAPEXアプリにサポートするオブジェクトとして含まれているため、個別に実行する必要はありません。
select model as r, model as d, provider
from (
select 'gpt-4o' as model, 'openai' as provider
union all
select 'gpt-5' as model, 'openai' as provider
union all
select 'o4-mini' as model, 'openai' as provider
--
union all
select 'google/gemmna-4-31b' as model, 'openai' as provider
union all
select 'mlx-community/gpt-oss-120b' as model, 'openai' as provider
union all
select 'claude-3-5-haiku-latest' as model, 'anthropic' as provider
union all
select 'claude-sonnet-4-0' as model, 'anthropic' as provider
union all
select 'claude-opus-4-1' as model, 'anthropic' as provider
union all
select 'gemini-2.5-pro' as model, 'google' as provider
union all
select 'gemini-2.5-flash' as model, 'google' as provider
union all
select 'gemini-2.5-flash-lite-preview-06-17' as model, 'google' as provider
union all
select 'qwen3:1.7b' as model, 'ollama' as provider
union all
select 'gemma3:4b' as model, 'ollama' as provider
union all
select 'gpt-oss:20b' as model, 'ollama' as provider
--
union all
select 'gemma4:31b' as model, 'ollama' as provider
union all
select 'cohere.command-a-03-2025' as model, 'oci' as provider
union all
select 'meta.llama-3.3-70b-instruct' as model, 'oci' as provider
)
where provider = :P0_PROVIDER
「Ajax call returned server error ORA-29273: HTTP request failed for Execute Server-Side Code.」
declare
l_result json_object_t;
begin
pame_pkg.reset_global_variables;
--
if :P0_PROVIDER = 'ollama' then
uc_ai.g_base_url := 'host.docker.internal:11434/api';
elsif :P0_PROVIDER = 'openai' and :P0_MODEL in ('google/gemma-4-31b','mlx-community/gpt-oss-120b') then
uc_ai.g_base_url := 'http://host.docker.internal:1234/v1';
uc_ai_openai.g_use_responses_api := false;
elsif :P0_PROVIDER = 'openai' then
uc_ai_openai.g_apex_web_credential := 'OPENAI_API_KEY';
end if;
l_result := uc_ai.generate_text(
p_user_prompt => :P1_USER_PROMPT,
p_system_prompt => :P1_SYSTEM_PROMPT,
p_provider => :P0_PROVIDER,
p_model => :P0_MODEL
);
:P1_OUTPUT := l_result.get_clob('final_message');
:P1_FULL_RESPONSE := l_result.to_clob;
end;
--
if :P0_PROVIDER = 'ollama' then
uc_ai.g_base_url := 'host.docker.internal:11434/api';
elsif :P0_PROVIDER = 'openai' and :P0_MODEL in ('google/gemma-4-31b','mlx-community/gpt-oss-120b') then
uc_ai.g_base_url := 'http://host.docker.internal:1234/v1';
uc_ai_openai.g_use_responses_api := false;
elsif :P0_PROVIDER = 'openai' then
uc_ai_openai.g_apex_web_credential := 'OPENAI_API_KEY';
end if;
drop table pame_settlement_demo;
drop table pame_files;
drop table pame_users;
delete from uc_ai_tools where code in ('PAME_CREATE_SETTLEMENT', 'PAME_GET_USER_INFO');
