Skip to content

Content Tagged "function"

Page 1 of 1

Content Tagged "function"

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…

Call an Oracle Function from Spring with CallableStatement

June 29, 2017Categories: Software, Tutorial
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 : The CallableStatementCreator sets up the statement and the CallableStatementCallback executes the statement and returns the value up to the…

Call an Oracle Function from Spring

June 29, 2017Categories: Software, Tutorial
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: This will return all flags for the panels matching the condition. Java Call The query string can be…

All tags