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

Question

I would like to call the PL / SQL stored procedure for which the OUT parameter is specified, but I do not need to return a value. I'm just curious that the procedure was successful, that is, there are no exceptions.

Do I have to define a dummy variable in my calling PL / SQL block to get the out parameter, although I don't want this? It clutters my calling code.

Answer 1

Yes, you will need to define a dummy variable.

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

Answer 2

sys_cursor .