"Clark, Harry" <Harry.Clark@knovalent.com> writes:

> create procedure createTempSchema (in schemaName char(254))
>   language java parameter style java modifies sql data
>   external name 'com.kve.vanguard.model.orm.dao.TempSchemaGenerator.createTempSchema';
:
> call app.createTempSchema('temp00');
> call app.createTempSchema('temp01');

Hi,

Did you look in derby.log for any error messages relating to the
calls?

Some suggestions:

I see you created the procedure without explicit schema, but call it
with explicit schema 'app'. Does it make a difference to use an
explicit app.createTempSchema when you create it? (should not be
necessary if app is the default schema already)

Have you verified that the classpath contains TempSchemaGenerator?

Dag