FAW - BI- Invalid credential name

Vasanthakumar Ravi

Hi All,

We are trying to run the below sql query in OAC BI Publisher using OAX_USER (data Source) getting 'Invalid credential name'. Please share your input if you have faced similer issue,

SQL Query

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

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

Error Message

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

Invalid credential name - TEMP_DATA_STORE.DATA_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

Regards,

Mallikarjuna Kuppauru-Oracle

Hi @Vasanthakumar Ravi

This is an Expected behavior you can't able to run the select command on dbms_cloud.

ORA-20004: Credential "OAX_USER"."OBJ_STORE_CRED" does not exist

DBMS_CLOUD is owned by a separate C##CLOUD$SERVICE schema.

Refer - How To Setup And Use DBMS_CLOUD Package (Doc ID 2748362.1)

https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_CLOUD.html#GUID-195B9635-3544-47BD-9AFE-B378F5E925B1

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @Vasanthakumar Ravi

I hope we have answered your question, Can you accept the same and close the thread.

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @Vasanthakumar Ravi

Any update on your thread? Can we conclude the same, if you are fine with responses.

Regards,

Arjun

Namrata Bhan-Oracle

@Vasanthakumar Ravi Could you please mark the appropriate answer as "accepted" in this thread?

This will allow other forum users to benefit from this thread as it will showcase and highlight the pertinent and valid answers, thereby allowing for a faster problem solution for other users experiencing the same issues as yourself.

Thank you,

Namrata