CODEWITHSUNDEEP
oracle-databasestored-proceduresplsql
aw crud
aw crud

Reputation: 8891

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

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.

Upvotes: 3

Views: 2409

Answers (2)

jitu
jitu

Reputation: 1

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

Upvotes: -1

cagcowboy
cagcowboy

Reputation: 30888

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

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

Upvotes: 10

Related Questions