I want several companies to work on the same database.

When a new company is added as a user, a new row is inserted in the
COMPANIES table.

When a new row is inserted in the COMPANIES, I want a new generator
to be created. The generator will be used to identify all the company
documents. A generator unique for all companies is not allowed for
several reasons that I won't post here.

I thought to have several generators created as GEN_1, GEN_2... GEN_N

A generator would provide the unique N.

However I stopped at the very beginning, as the following test SP
won't compile:

create procedure test
returns
as
begin
create generator one;
end

The error message is: 'token unknow "create"'

Is there no way to create a generator from a SP ?

TIA

Duilio Foschi