Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.litech.org!news.glorb.com!newsfeed2.telusplanet.net!newsfeed.telus.net!edtnps90.POSTED!53ab2750!not-for-mail From: HansF Subject: Re: any ideas on why this pice of code dosnt work?? User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) Message-Id: Newsgroups: comp.databases.oracle.server References: <1155055659.151278.191510@m73g2000cwd.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 29 Date: Tue, 08 Aug 2006 17:15:14 GMT NNTP-Posting-Host: 142.59.224.167 X-Trace: edtnps90 1155057314 142.59.224.167 (Tue, 08 Aug 2006 11:15:14 MDT) NNTP-Posting-Date: Tue, 08 Aug 2006 11:15:14 MDT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272382 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 ... -- 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.