Forum Discussion

ChristianR's avatar
ChristianR
Frequent Visitor
5 years ago

Oracle - 2 queries in 1 dataset for setting decryption key

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
 
Data Protection
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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