Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: postbus@sybrandb.demon.nl (Sybrand Bakker) Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: Execute immediate problem Date: 6 Jun 2002 01:43:20 -0700 Organization: http://groups.google.com/ Lines: 37 Message-ID: References: <3CFE976E.8040103@xs4all.nl> NNTP-Posting-Host: 145.13.42.4 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1023353001 28600 127.0.0.1 (6 Jun 2002 08:43:21 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 6 Jun 2002 08:43:21 GMT Xref: easynews comp.databases.oracle.misc:82565 comp.databases.oracle.server:149707 comp.databases.oracle.tools:51673 X-Received-Date: Thu, 06 Jun 2002 03:44:47 MST (news.easynews.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 As your post is intentionally vague, providing no more information than 'It doesn't work' and you can't expect anyone going to set up a similar case, and crystall balls have been worn out here, please try to be as precise as possible, or don't expect accurate responses Regards Sybrand Bakker Senior Oracle DBA