V_SQL CLOB; V_SQL := DBMS_LOB.SUBSTR(V_SQL,DBMS_LOB.GETLENGTH(V_SQL)-2,1) || ' IS NOT NULL'; EXECUTE IMMEDIATE V_SQL USING V_PARAM1,V_PARAM2; COMMIT;