How can I call a PL/SQL procedure without specifying a variable to hold its OUT parameter?

Question

I'd like to call a PL/SQL stored procedure that has an OUT parameter specified, but I don't care about the return value. I just care that the procedure executed successfully, i.e. no exceptions thrown.

Do I have to define a dummy variable in my calling PL/SQL block to receive the out parameter even though I don't want it? It clutters up my calling code.

Answer 1

Yes, you'll have to define a dummy variable.

Or write a wrapper proc that ignores the variable you don't care about?

Answer 2

Use sys_cursor to retrieve all the columns inside the procedure..