Oracle Stored Procedure Not Supported?

[compscinj]

I have a report that I am attempting to have call a stored procedure inside of an Oracle database. In order to make this as  simple as possible to debug, my SP is simply:

create or replace PROCEDURE test_proc IS 
    varOne VARCHAR2(20) := 'hello';
    varTwo VARCHAR2(20) := 'world';
BEGIN
    DBMS_OUTPUT.PUT_LINE( varOne|| ' ' || varTwo);
END test_proc;

Inside of Power BI, I connect to the database server and give the following SQL statement:

BEGIN
  test_proc();
END;

The SP works fine when called from anywhere else. When called from Power BI, the first error I recive says:

Details: "EvaluateNativeQueryUnpermitted failure: the query 'BEGIN
test_proc();
END;' isn't approved for execution."

I then hit "retry" on the dialog box that contains that error, it then brings the popup to ask if I want to allow the native database query. I hit "Run" and then I get an error that says: 

Details: "This native database query isn't currently supported."

So, are stored procedure calls to Oracle databases not supported? 

[v-jiascu-msft]

Hi @compscinj,

I'm afraid the stored procedure isn't supported by now. I tested it and got the same error. Please vote on an idea or create a new one here.

Best Regards,

Dale

[compscinj]

Thank you for the response.