Calling stored proc via JDBC

[martynh]

I'm sure this should be simple, but the dev team haven't done this before. They are having problems calling a stored proc that requires an input parameter of type VARCHAR(255).

The start of the proc reads:

create procedure GETNEXTID
(in TABNAME varchar(255), out NEXTID bigint)
language SQL

Could someone possibly provide us with the code fragment necessary?

Thanks

Martyn Hodgson
On behalf of NorPay Solutions