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

Previous slide

Next slide

Back to first slide

View graphic version

This script calls the stored procedure with simple IN and OUT parameters.