Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!jfk3-feed1.news.algx.net!allegiance!news.maxwell.syr.edu!fu-berlin.de!uni-berlin.de!213.145.128.88!not-for-mail From: "Roman Mirzaitov" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: Execute immediate problem Date: Thu, 6 Jun 2002 11:03:48 +0600 Lines: 44 Message-ID: References: <3CFE976E.8040103@xs4all.nl> NNTP-Posting-Host: 213.145.128.88 X-Trace: fu-berlin.de 1023339827 586536 213.145.128.88 (16 [127142]) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.misc:82562 comp.databases.oracle.server:149693 comp.databases.oracle.tools:51669 X-Received-Date: Wed, 05 Jun 2002 22:02:30 MST (news.easynews.com) Hi, I guess it depends not on script size, but on user priviligies. Be sure that user has enough privilegies to perform script actions and these privs must be granted directly, not through roles. Regards, -- Roman Mirzaitov Brainbench MVP for Oracle Administration www.brainbench.com "Geert Roelof" wrote in message news:3CFE976E.8040103@xs4all.nl... > 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 >