我认为问题是因为你在比较中拼错了表的名称。如果你使用像execute immediate这样的动态方法会更好。我将向您展示如何：
首先，创建一个数据库PROCEDURE以执行update命令。

create or replace PROCEDURE DELETE_OPERATION
  ( 
    P_ID      number , 
    P_TABLE  VARCHAR2, 
    P_USER    VARCHAR2 , 
    P_NOTES VARCHAR2 )
AS
v_cmd VARCHAR2;
BEGIN
    v_cmd := 'UPDATE ' || P_TABLE || ' SET ISDELETED = 1, DELETE_TIME = LOCALTIMESTAMP, DELETE_USER = :1, DELETE_NOTE = :2;'
    || ' WHERE ID = ' TO_CHAR(P_ID);

    execute immediate v_cmd USING P_USER, P_NOTES ;
END;

然后替换此代码。

BEGIN
    IF :P32_TABLE = 'TBLCASE' THEN
        UPDATE TBLCASE SET ISDELETED = 1, DELETE_TIME = LOCALTIMESTAMP, DELETE_USER = :APP_USER, DELETE_NOTE = :P32_NOTE:
        WHERE ID = :P32_ID;
    ELSIF :P32_TABLE = 'TBLCASECALSS' THEN
        UPDATE TBLCASECLASS SET ISDELETED = 1, DELETE_TIME = LOCALTIMESTAMP, DELETE_USER = :APP_USER, DELETE_NOTE = :P32_NOTE:
        WHERE ID = :P32_ID;
    ELSIF :P32_TABLE = 'TBLCASEDOCUMENT' THEN
        UPDATE TBLCASEDOCUMENT SET ISDELETED = 1, DELETE_TIME = LOCALTIMESTAMP, DELETE_USER = :APP_USER, DELETE_NOTE = :P32_NOTE:
        WHERE ID = :P32_ID;
    ELSIF :P32_TABLE = 'TBLCASEEND' THEN
        UPDATE TBLCASEEND SET ISDELETED = 1, DELETE_TIME = LOCALTIMESTAMP, DELETE_USER = :APP_USER, DELETE_NOTE = :P32_NOTE:
        WHERE ID = :P32_ID;
    END IF;
END;

用这个：

BEGIN
    DELETE_OPERATION(:P32_ID, :P32_TABLE, :APP_USER, :P32_NOTE);
END;