exec immediate ..... why
VSQL := L1.V1
invalid character
ORA-00911: invalid character
ORA-06512: at line 26
DECLARE
CURSOR C1 IS
SELECT 'grant all on ' || OWNER || '.' || TABLE_NAME || ' to CAMA;' V1
FROM ALL_TABLES
WHERE OWNER LIKE 'CAMA%'
AND OWNER <> 'CAMA';
BEGIN
VSQL VARCHAR2(250);
FOR L1 IN C1 LOOP
VSQL := L1.V1;
EXECUTE IMMEDIATE VSQL;
END LOOP;
END;
/