Oracle plsql calling procedure using java

When you need to call an Oracle stored procedure from Java JDBC, CallableStatement is the right approach. The {call procedure_name()} syntax is standard JDBC callable statement notation. Using try-with-resources ensures the connection and statement are properly closed even if an exception is thrown.

• sample procedure

create or replace procedure proc_truncate_table
is
begin
 execute immediate 'truncate table data_table';
end;

* calling above procedure from jdbc

```console
try (Connection connection = getConnection()) {
    try (CallableStatement statement = connection.prepareCall("{call proc_truncate_table()}")) {
        statement.execute();
    }
}