Advertisements
Offline
ravindrareddy.ganji
Posts: 1
Joined: Sun Oct 14, 2012 9:54 am
what is the return type of callable statement in JDBC

ยป

Postby daniel88 » Fri Dec 28, 2012 10:41 am

Offline
daniel88
Posts: 11
Joined: Thu Dec 27, 2012 12:37 pm
Location: VIET NAM
A Simple Example of callable statement is give below which calls the stored procedure HI() from database student.

At first create a database student in MySql Then Create a Stored procedure in the database as

DELIMITER //
REATE PROCEDURE `HI`()
BEGIN
SELECT 'HI FRIEND !' AS MESSAGE;
END //
DELIMITER;