Updating sequences .. WAS ddl plsql can someone spot the error

Can someone recommend a way to update some sequences via a script?

I have a big set of schemas (how have some sequences that need setting), and I'd like to run a script for each schema that

• looks at the max for a table.column
• sets a sequence number I am using to populate this column to one greater

This is done for a set of about 10 table/sequence number pairs.

I tried plsql, howver I had problems mentioned previously, and I thought maybe I was going through overkill.

Thanks
Jeff Kish Received on Tue May 06 2003 - 13:50:06 CDT