Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!eusc.inter.net!newsfeed.stueberl.de!news2.euro.net!transit.news.xs4all.nl!not-for-mail From: Geert Roelof Newsgroups: comp.databases.oracle.server Subject: Re: Execute immediate problem. Dear Mr. Morgan... Date: Thu, 06 Jun 2002 08:38:58 +0200 Organization: XS4ALL Internet BV Lines: 92 Message-ID: <3CFF0382.6070909@xs4all.nl> References: <3CFE976E.8040103@xs4all.nl> <3CFEEA2F.EDD97C06@exesolutions.com> NNTP-Posting-Host: a80-126-12-196.adsl.xs4all.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news1.xs4all.nl 1023345260 17234 80.126.12.196 (6 Jun 2002 06:34:20 GMT) X-Complaints-To: abuse@xs4all.nl NNTP-Posting-Date: 6 Jun 2002 06:34:20 GMT User-Agent: Mozilla/5.0 (Windows; U; Win98; en-GB; rv:0.9.4) Gecko/20011019 Netscape6/6.2 X-Accept-Language: en-gb Xref: easynews comp.databases.oracle.server:149700 X-Received-Date: Thu, 06 Jun 2002 01:05:22 MST (news.easynews.com) Daniel Morgan wrote: > 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 > > So you want some more information? >I don't mean to be harsh here but this is a rant that has been repeated >many times in this group. I dont know with you but i don not search every time through the whole newsgroup. So if it is repeated and a known problem why not just state that fact and give me a help. > 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. I thought i wrote the error was 'not enough priviliges' . But if you want a number thats fine with me. I posted this message from my home and not from the desk i work. I did it from memory. The error should be: insufficient privileges. Just don't tell me i am not a senior developer because i don't give you all the numbers. The problem can be a general one, and i didn't find anything on metalink. Besides that fact I am not a DBA so i just don't know all of the hardware facts. The numbers mr. Morgan: ORA-1031: insufficient priviliges Platform UNIX but then you want to know the exact version and which flavour I suppose RDBMS 8.1.7 Hardware I don't know but if you insist on getting the numbers right then i need to ask a DBA for that information. Finally, as you can see: for your convenience i only posted it on cdo.server. With regards, G.R. van der Ploeg