Oracle - 2 queries in 1 dataset for setting decryption key

[ChristianR]

Using Oracle 19c as a data source.  I need to set the decryption key for some column on my Oracle session.

In Oracle SQL Developer we typically do these 2 statements separated by Semi Column

select crypt_data.setkey('xxxxxxxxxxxxx') val from dual;

select CAST(crypt_data.decryptor(taxid) AS VARCHAR2(9)), taxid from entity where codenbr='xx';

In Power BI, when I do the same I get "We encountered an error while trying to connect. Details: "Oracle: ORA-00933: SQL command not properly ended"

What is the way to get around this?

Thank you

[ChristianR]

This wouldn't work for the decryption piece.  

[Anonymous]

HI @ChristianR,

Do you mean this issue only appears when you add the encryption/decryption parts to advanced queries?
If that's the case, you can trace the connection sessions on the database side to confirm if they have enough permissions to execute or have been blocked by power bi itself. (some functions or features will be limit use when you use with the data connector due to security reasons)
Regards,
Xiaoxin Sheng

[Anonymous]

HI @ChristianR,

I'd like to suggest you mix them into one query, power bi seems not support invoke multiple SQL statements at the same time.

Regards,

Xiaoxin Sheng