CREATE OR REPLACE PROCEDURE SP_DEL_ARCHIVE_TARGET ( archtable VARCHAR2)
First, you should specify what type of parameter you are passing in. IN is the default, so if you don't specify IN, then IN is what it is. Challenge: find any book on PL/SQL that doesn't recommend always specifying the type of parameter. However, that is not your error here.

IS


Convention is to use AS, not IS, but this is not the error either

EXECUTE IMMEDIATE 'DELETE ' || archtable || ' WHERE ROWID = :vrowid' USING tRowID ;


How is :vrowid being recognized by the execute immediate command? Doesn't that make :vrowid a string value, and not a bind variable?