FAW -- Invalid credential name

Question

Hi All,

We are running the below sql query in OAC BI publisher and getting 'Invalid credential name'. Please share your input if you have faced similer issue.

SQL Query

=======================================

select *

from   dbms_cloud.list_objects(

'XX_DATA_STORE.XX_STORAGE_CREDENTIALS',

'https://objectstorage.uk-london-1.oraclecloud.com/n/{my-namespace}/b/ob-bucket/o/');

Error Message

========================================

Invalid credential name - XX_DATA_STORE.XX_STORAGE_CREDENTIALS ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240425_1", line 2060 ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240425_1", line 12567 ORA-06512: at line 1

Sumanth V -Oracle · Answer

@Vasanthakumar Ravi - This seems to be duplicate of below thread, please close one as duplicate to avoid ambiguities.

https://community.oracle.com/products/oracleanalytics/discussion/21616/faw-bi-invalid-credential-name

Mallikarjuna Kuppauru-Oracle · Answer

Hi @Vasanthakumar Ravi

Its seems like an duplicate post. Please proceed your followup/comments on other post.

Regards,

Arjun