开发者

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

开发者 https://www.devze.com 2022-12-23 00:48 出处:网络
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 throw

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..

0

精彩评论

暂无评论...
验证码 换一张
取 消