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.
Yes, you'll have to define a dummy variable.
Or write a wrapper proc that ignores the variable you don't care about?
Use sys_cursor to retrieve all the columns inside the procedure..
精彩评论