Callable Statement program to Insert Records | JDBC Tutorials Online

This JDBC Tutorials Online “CallableSatement program” post explains clearly how to execute a stored procedure using callable statement interface to insert records into database table from jdbc application.


 

Create Table :

sql> create table simple(num number(5));
table created;

 

Creating stored procedure to insert data into ‘simple’ table:

sql>CREATE OR REPLACE PROCEDURE insertnumber(no number)
sql>IS
sql>BEGIN
sql>insert into simple(num) values(no);
sql>END;
sql>/
procedure created successfully.

 

 

Share this