Skip to content

Content Tagged "procedure"

Page 1 of 1

Content Tagged "procedure"

Display a Function's Errors in Oracle

June 30, 2017Categories: Software, Tutorial
TL;DR: Use the power of DBMS_OUTPUT.PUT_LINE , Luke! I've built a function along the lines of: When using the function, I got some 0 results and I wanted to know why. The solution I got was using DBMS_OUTPUT.PUT_LINE : Now, all you have to do is enable DBMS_OUTPUT in your environment and you…

PostgreSQL: Call a Stored Procedure for Every Row

May 13, 2014Category: Software
I guess that newbies in PostgreSQL like me have first question when they create a store procedure: How do I call it? The answer is simple; you just execute Then, usually immediately the second question pops up: I wrote a procedure which I need to call for each row in a table. How do I do that? The…

All tags