Abstract. Stored procedure has occurred independently in database application systems. How to test the stored procedure effectively becomes an urgent problem in automated testing. Test data generation is a vital part in automated test of stored procedure. However, the current approaches of test data generation for stored procedure needs manual intervention and the solution of the constraint system which limits test data can not effectively cover all the situations. Existing approaches can not solve constraint system with character string and strict inequality. This paper improved the approach to generate test data, perfected existing approach to solve constraint system and reduced the limitation on solving the constraint system
