Executing oracle stored procedures in packages

[Håvard]

Hello, I am trying to run a stored procedure which is located within an oracle package. The report wizard does not locate these stored procedures, so I have tried to write an SQL statement which should execute it. However when I test it, no rows are returned (no error messages given).

What is the correct syntax to achieve this? 

 

This is my current attempt:

DECLARE 
  P_VAR1 NUMBER;
  P_VAR2 NUMBER;
  p_cursor sys_refcursor;

BEGIN 
  ​P_VAR1 := 123;
  P_VAR2 := 456;
  p_cursor:= NULL;

  NII.​MYPACKAGE.MY_PROCEDURE( P_VAR1, P_VAR2, p_cursor);
  COMMIT; 
END; 

 

 

[Nasko]

Hello Håvard,

Please check if the issue is related to the package configuration as described in this thread.

Also, try to execute the stored procedure programmatically and then return the retrieved data to the report using the ObjectDataSource Component.

Regards,
Nasko
Telerik