The below procedure returns the count of rows in a table. I need to call this Sprocedure from batch file. I need to use the value returned from the procedure in the batch file.
CREATE PROCEDURE get_count()
DECLARE CNT INTEGER;
select count(*) into CNT from administrator.test_title;
Please give a solution for this. Thanks!.