Re: any ideas on why this pice of code dosnt work??

Yes.

You probably would as well, if you attempted to run it and *read* the associated error message.

For you amusement, I refer you to the documedntation, and in particular the "OracleŽ Database PL/SQL User's Guide and Reference, 10g Release 2 (10.2)" when in Chapter 7 (at
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14261/dynamic.htm) one can *read* such inane and useless information such as

"

You need dynamic SQL in the following situations:

• You want to execute a SQL data definition statement (such as CREATE), a data control statement (such as GRANT), or a session control statement (such as ALTER SESSION). Unlike INSERT, UPDATE, and DELETE statements, these statements cannot be included directly in a PL/SQL program.
  "
  

Of course, as a developer, you might find *reading* to be boring. In which case, you will be asking a lot of these types of questions ... <g>

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.