Forum Discussion
Resolver IOracle Stored Proc in PBI Desktop
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.
Resolver IWithin Oracle:
CREATE OR REPLACE PROCEDURE [SCHEMA].[STOREDPROCNAME]
( P_RC OUT SYS_REFCURSOR )
AS
BEGIN
OPEN P_RC FOR SELECT COL1,COL2,COL3 BLAH BLAH BLAH
END;
Within Power BI Desktop:
DECLARE P_RC SYS_REFCURSOR;
BEGIN
[SCHEMA].[STOREDPROCNAME](P_RC);
DBMS_SQL.RETURN_RESULT(P_RC);
END;
Hope this helps.
Regards
Rakesh Singh
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?
sravanpesari were you able to resolve the issue. I am facing the same issue in directquery mode. Do you have any suggestions
