Re: prepared statement call fails

Larry White wrote:

>         proc = connection.prepareCall("{ ? =  call add_country( ? ? ? ? ) }");

You are missing commas between your ? parameter placeholders.

Try:

   proc = connection.prepareCall("{ ? =  call add_country(?,?,?,?) }");

Otherwise your code looks OK.

It may be useful to turn on statement logging on the server side if you
have more problems -- the JDBC driver is transforming your query and it
can be useful to see exactly what's getting sent to the server.

-O