Re: Execute immediate problem

Geert Roelof wrote:

> Hello,
>
> I build a pl/sql procedure which generates pl/sql. I use a dummy script
> and some variables. Those variables are the replace and the whole
> generated pl/sql code is executed by using EXECUTE IMMEDIATE (V_SCRIPT)
>
> V_Script is defined as varchar2(32767)
>
> The following problem occurs. When I generate a script which is less
> then 2000 characters long everything works fine. But when i generate a
> script which is larger then 2000 characters it fails with the error: Not
> enough privileges. (?) I check the code and its correct, but i cannot
> get it into the database with an execute immediate.
>
> The documentation states that execute immediate can handle scripts as
> large as 32K so what is happening here?
>
> Does anyone out there have a clue?
>
> Any suggestions are welcome
>
> Thanks in advance
>
> G.R. van der Ploeg
> Senior developer
> Geove/RZG

I don't mean to be harsh here but this is a rant that has been repeated many times in this group.

I am stricl by the fact that under your name you wrote "Senior developer" but you didn't think it important to give us the actual error message. Neither do I see a platform, an operating system, or an Oracle version. Any chance you could make it easier on those that might wish to help you?

And as long as I am both trying to help you and ranting a bit ... please don't multipost. This message should only be posted to c.d.o.server. It is not miscellaneous and it has nothing to do with Oracle tools.

Daniel Morgan Received on Wed Jun 05 2002 - 23:50:55 CDT