Posts Tagged ‘RETURN’

Return in a PL/SQL Procedure – Just one more thing Mum never told me

February 10, 2010

Functions return values. Procedures pass out parameters. That’s the way it is, that’s the way it’s always been. Or that’s what I thought up until recently.
Turns out that procedures can return too. I don’t know why I hadn’t realised this before. Maybe I’m just too set in my ways, or maybe it’s not just me.
Yes, I hear you cry, but RETURN in a procedure won’t pass back a value, so why would it be useful ? Time for another trivial example… (more…)


Follow

Get every new post delivered to your Inbox.

Join 57 other followers