drop and create sequence from a stored procedure

[liorjsb]

Thanks, it helped and I don't get the invalid number
but I still get insufficient privileges for creating the sequence even though the user has it and can create it.

how can I check if the sequence exists before I create it? or just set it to a different value.

Thanks