PL/SQL (MOSC)

MOSC Banner

exec immediate ..... why

edited May 13, 2016 5:20AM in PL/SQL (MOSC) 8 commentsAnswered

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;

/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center