Java SP Wrapper - 5
Calling the wrapper sp:
BEGIN
DECLARE to_be_searched VARCHAR ( 100 );
DECLARE search_for VARCHAR ( 100 );
DECLARE last_index INTEGER;
SET to_be_searched = '56785678';
SET search_for = '5678';
CALL sp_demo_proc
( to_be_searched,
search_for,
last_index );
MESSAGE 'test: last_index = ', last_index;
END
Notes:
This script calls the stored procedure with simple IN and OUT parameters.