Functions Executions in Database from JDBC| JDBC Tutorials 

This JDBC Tutorials  “Functions Executions in Database from JDBC” post explains about how to execute functions in Database from JDBC application using CallableStatement.


 

Functions in Database:

  • Function is a set of instructions is taking input, process input and return output.
  • Input can be passed using “in” parameter.
  • Return value can be collected using “out” parameter.

 

Define Function:

create or replace function StuFun (a in number, b in number, n1 out number)
return number as
n2 number;
begin
n1:=a*b;
n2:=a+b;
return (n2);
end;
/

 

Share this