Laur's blog
  • Home
  • About
  • Support my work
Sign in Subscribe

procedure

A collection of 2 posts
Display a Function's Errors in Oracle
dbms

Display a Function's Errors in Oracle

TL;DR: Use the power of DBMS_OUTPUT.PUT_LINE, Luke! I've built a function along the lines of: CREATE OR REPLACE FUNCTION HAS_PANEL_FLAG_OK( P_USER_ID in USERS.USER_ID%TYPE, P_PANEL_ID in PANELS.PANEL_ID%TYPE, ) RETURN integer IS lv_count
Jun 30, 2017 1 min read
PostgreSQL: Call a Stored Procedure for Every Row
call

PostgreSQL: Call a Stored Procedure for Every Row

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 SELECT your_procedure_name(parameters); Then, usually immediately the second question pops up: I wrote a procedure which I need to
May 13, 2014 1 min read
Page 1 of 1
Laur's blog © 2025
  • Sign up
Powered by Ghost