Database Software

I have been following all the steps to implement Select AI with (RAG) from Oacle blog: https://blogs.oracle.com/machinelearning/post/announcing-select-ai-with-rag-on-adb?source=:so:fb:or:dg:odb:::RC_WWMK240603P00031:OCW24ADB&SC=:so:fb:or:dg:odb:::RC_WWMK240603P00031:OCW24ADB&pcode=WWMK240603P00031 .

When all steps are done, the vector table stays empty and “select * from user_cloud_pipeline_history” shows a row with status failure and error_message: “ORA-06576: not a valid function or procedure name”.

All credentials are checked and are working.

Any help to fix this would be very much appreciated!

Executed statements:

BEGIN
dbms_cloud_ai.drop_profile('OPENAI_TEXT_TRANSFORMER');
DBMS_CLOUD_AI.CREATE_PROFILE(
  profile_name => 'OPENAI_TEXT_TRANSFORMER',
  attributes => '{"provider": "openai",
                  "credential_name": "OPENAI_CRED",
                  "embedding_model": "text-embedding-ada-002" }');
END;

BEGIN
DBMS_CLOUD_AI.DROP_VECTOR_INDEX('MY_VECTOR_INDEX'); 
DBMS_CLOUD_AI.CREATE_VECTOR_INDEX(
  index_name => 'MY_VECTOR_INDEX',
  attributes => '{"vector_db_provider": "oracle",
                  "location": "https://objectstorage.eu-amsterdam-1.oraclecloud.com/n/axx994e8pjok/b/SergeiTestBucket/o/",
                  "object_storage_credential_name": "OCI_TESTBUCKET_CRED",
                  "profile_name": "OPENAI_TEXT_TRANSFORMER",
                  "vector_dimension": 1536,
                  "vector_distance_metric": "cosine",
                  "chunk_overlap":128,
                  "chunk_size":1024}'); 
END;