Hi

> Can we safeley create a stored procedure in a transaction(where no DML

occurs), commit this transaction then start a new transaction and do DML
using this stored procedure in this new transaction(assuming above mentioned
dependancies are managed and procedure 'compiles' when it is commited). And
at the same time have other DML operations occuring in seperate transaction
?

I don't know this, but there is one way to be absolutely sure: Make
modifications to the SPs and shut down the database. Reopen it and
everything should be fine.
Since embedded is single-user, there should not be a problem in shutting
down the database.

One other opinion is, that if your SPs do not depend on each other (which I
read from your usage description) and you can assure, SP names to be used
only once (simply append the value of a generator), then it should be
possible to use these SPs right after committing and delete them
accordingly. But do not reuse names.

Regards,
Steffen