Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!p79g2000cwp.googlegroups.com!not-for-mail
From: "Vinay Bhushan" <bhushanvinay@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: any ideas on why this pice of code dosnt work??
Date: 8 Aug 2006 11:03:59 -0700
Organization: http://groups.google.com
Lines: 36
Message-ID: <1155060239.209383.132260@p79g2000cwp.googlegroups.com>
References: <1155055659.151278.191510@m73g2000cwd.googlegroups.com>
   <pan.2006.08.08.17.17.47.489905@gmail.com>
NNTP-Posting-Host: 217.150.124.194
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1155060245 17855 127.0.0.1 (8 Aug 2006 18:04:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 18:04:05 +0000 (UTC)
In-Reply-To: <pan.2006.08.08.17.17.47.489905@gmail.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 ISA1
Complaints-To: groups-abuse@google.com
Injection-Info: p79g2000cwp.googlegroups.com; posting-host=217.150.124.194;
   posting-account=abu5ww0AAAChYpGYX4xAp4LCgZH2xuHr
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272385

Sorry for making it a dual post.

Regards
Vinay
HansF wrote:

> 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=AE 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/dynam=
ic.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.