"Clark, Harry" <[email protected]> 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
