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.

sravanpesari's avatar
sravanpesari
Frequent Visitor
2 years ago

Rakesh, it's working perfect in Import mode. when I used the same syntax in Direct mode, it's giving syntax error like right paranthesis missing.

  How we can call in Direct Query mode?

ChaitanyaRatna's avatar
ChaitanyaRatna
New Member
1 year ago

sravanpesari were you able to resolve the issue. I am facing the same issue in directquery mode. Do you have any suggestions