Required prerequisites

• I have searched the Issue Tracker and Discussions that this hasn't already been reported. (+1 or comment there if it has.)
• Consider asking first in a Discussion.

Motivation

With version updates, OceanBase docs recommend using ObVecClient.create_index with vidx_params when
working in ObVecClient mode, Our current OceanBaseStorage always builds an
IndexParams object and calls create_vidx_with_vec_index_param, which doesn’t align
with the recommended ObVecClient workflow.

reference:

• Current implementation: camel/storages/vectordb_storages/oceanbase.py (index
  creation logic).
• https://www.oceanbase.com/docs/common-oceanbase-database-standalone-1000000003577788#5-title-ObVecClient
• https://github.com/oceanbase/pyobvector

Solution

• Add optional parameters like index_name and vidx_params to
  OceanBaseStorage.init (default vidx_params: distance=l2, type=hnsw, lib=vsag).
• After table creation, prefer calling create_index(... is_vec_index=True,
  column_names=["embedding"], vidx_params=...).

Alternatives

No response

Additional context

No response