Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Daniel Morgan <damorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: Execute immediate problem
Date: Wed, 05 Jun 2002 21:50:55 -0700
Organization: EXE
Message-ID: <3CFEEA2F.EDD97C06@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.8 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
References: <3CFE976E.8040103@xs4all.nl>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 43
Xref: easynews comp.databases.oracle.misc:82560 comp.databases.oracle.server:149688 comp.databases.oracle.tools:51668
X-Received-Date: Wed, 05 Jun 2002 21:49:28 MST (news.easynews.com)

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