Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: any ideas on why this pice of code dosnt work??
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Ž 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.
Received on Tue Aug 08 2006 - 13:03:59 CDT