Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Pepe Mujin]

Folks, ?I am struggling to pull some tables from an oracle database. I am required to pass somehow the following oracle statement:

Set role all

 

But when I try to do this, I got an error stating that this is not a valid sql statement 

let
    Source = Oracle.Database(“mwks399083:1521/owr5000″, [HierarchicalNavigation=true, Query=”set role all”]),
    OWSYS = Source{[Schema=”OWSYS”]}[Data]
in
    OWSYS

 Expression.Error: This native database query isn’t currently supported.

Please note that I am able to connect to the database..  Any Advise will be greatly appreciated

Best Regards,
Jorge Castellano

——————————
Jorge Castellano

——————————

[Audrey Abbey]

Jorge, 

I am not that familiar with Oracle, but I think that “SET ROLE ALL” is supposed to go in front of an actual SQL Query. 

That should probably look something like:

Query=”SET ROLE ALL; SELECT  * FROM table; “

You don’t have a valid query in your query string. 
You just have the SET command. 

Best, 
Audrey

——————————
Audrey Abbey
SR. BI Developer/Analyst
New Seasons Market
Portland OR
——————————
——————————————-

[Pepe Mujin]

Source = Oracle.Database(“mwks399083:1521/owr5000″, [HierarchicalNavigation=true, Query=”set role all; select * from dsd_norway.well_master;”])

?DataSource.Error: Oracle: ORA-00933: SQL command not properly ended
Details:
    DataSourceKind=Oracle
    DataSourcePath=mwks399083:1521/owr5000
    Message=ORA-00933: SQL command not properly ended
    ErrorCode=-2147467259

——————————
Jorge Castellano

——————————
——————————————-