The simplest way to integration test your stored procedures is with jOOQ and testcontainers| Java, SQL and jOOQ.