generic JdbcAdapter for stored procedures

, ,
1

Hi wmusers!

Maybe someone cane help me here. I have a oracle databse with almost 50 stored procedures. Every procedure have the same one IN and one OUT variable (in VARCHAR, out VARCHAR). I don’t want to make 50 adapters, so here comes the question. Is this possible to make a generic jdbc adapter with procedure name as a parameter?

I can’t change procedures - one in var, one out var.

2

one workaround I can think of:
create another SP:
with two in, one out
the 2nd IN parameter is the sp name

this new SP will decide which SP to call based on the 2nd in parameter