Laur's blog
Sign in Subscribe

function

A collection of 3 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
Call an Oracle Function from Spring with CallableStatement
call

Call an Oracle Function from Spring with CallableStatement

Following the previous post, I wondered if there's a more elegant way to call a function. It turns out there is and it's based on CallableStatement: int value = jdbcOperations.execute( new CallableStatementCreator() { // ... }, new CallableStatementCallback<Integer>() { // ... } ); The CallableStatementCreator sets up the statement and the CallableStatementCallback
Jun 29, 2017 1 min read
Call an Oracle Function from Spring
function

Call an Oracle Function from Spring

The easiest way to call a function from Spring is using SELECT. For example, having a function HAS_PANEL_FLAG_OK with two parameters and returning an integer, the function call looks like: SELECT panel_id, HAS_PANEL_FLAG_OK('17584', panel_id) AS flag FROM panels WHERE
Jun 29, 2017 1 min read
Page 1 of 1
Laur's blog © 2025
  • Sign up
Powered by Ghost