Error - Identifier must be declared

[Running Bear]

Dapi,

That has sorted it. Thanks for all your help really, really appreciated!

CREATE OR REPLACE PROCEDURE Set_Sequences (pk_name IN VARCHAR2, table_name IN VARCHAR2) IS
max_pk NUMBER;

BEGIN
EXECUTE IMMEDIATE ('SELECT max('|| pk_name ||') From ' || table_name) INTO max_pk;

EXECUTE IMMEDIATE ('drop sequence ' || pk_name);

EXECUTE IMMEDIATE ('create sequence ' || pk_name || ' start with ' || max_pk || ' increment by 1 minvalue 1 nocycle cache 20 noorder');

COMMIT;
END;

Thanks for the link to the user guide, will come in handy in the future.

Cheers Al