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;