{"id":61360,"library":"otl","title":"OTL","description":"Oracle, Odbc and DB2-CLI Template Library for database access.","status":"active","version":"4.0.502","language":"cpp","source_language":null,"source_url":null,"tags":["database","odbc","oracle","db2","template"],"install":[{"cmd":"vcpkg install otl","lang":"bash","label":"vcpkg"},{"cmd":"# CMakeLists.txt\nfind_package(otl CONFIG REQUIRED)\ntarget_link_libraries(main PRIVATE otl::otl)","lang":"cmake","label":"CMake"}],"dependencies":[],"imports":[{"symbol":"otlv4.h","correct":"#include <otlv4.h>"}],"quickstart":{"code":"#include \"otlv4.h\"\n\nint main() {\n    otl_connect db;\n    db.rlogon(\"user/password@database\");\n    otl_stream s(1, \"SELECT * FROM table\", db);\n    return 0;\n}","lang":"cpp","description":"Connect to a database and execute a query"},"warnings":[{"fix":"Ensure the appropriate database client libraries are linked in your project.","message":"OTL is header-only but requires linking with database client libraries (e.g., OCI, ODBC).","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'access':12 'cli':7 'databas':11,13 'db2':6,16 'db2-cli':5 'librari':9 'odbc':3,14 'oracl':2,15 'otl':1 'templat':8,17","created_at":"2026-06-17T04:47:32.499402+00:00","updated_at":"2026-06-17T04:47:32.499402+00:00","problems":[],"ecosystem":"vcpkg","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-17","next_check":"2026-12-14","install_tag":null}}