Forum Discussion

RakeshSinghr's avatar
RakeshSinghr
Icon for Resolver I rankResolver I
6 years ago
Solved

Oracle Stored Proc in PBI Desktop

Hi,       I need help with executing an oracle stored procedure that simply returns few columns. I'm getting "Oracle:ORA00900: invalid SQL statement" error.   I'm using ref cursor - see below co...
Need Help
  • RakeshSinghr's avatar
    RakeshSinghr
    6 years ago

    For anyone in the same boat as me - Oracle stored proc with ref cursors can be executed within power bi desktop. It just need to be run with cursor variable declaration.

klinejordan's avatar
klinejordan
Icon for Advocate II rankAdvocate II
4 years ago

Anonymous did you ever get this working (calling Oracle stored procedure through gateway)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey klinejordan ! No, this is a known limitation that is well described on the online documentation, I just couldn't find that document before opening my question in here.

 

Mark Vaillancourt pointed me out to the document where this is disclosed:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#capabilities-supported

 

"If you want to import data by using a native database query, put your query in the SQL statement box, which appears when you expand the Advanced options section of the Oracle database dialog. Power BI Desktop does not support Oracle native queries that execute a stored procedure and Oracle native queries in "begin ... end" block does not return any result set."