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

dbms

A collection of 1 post
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
Page 1 of 1
Laur's blog © 2025
  • Sign up
Powered by Ghost