Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Has anyone heard of a 64KB limit for ONE stored proc in Oracl e 817

Re: Has anyone heard of a 64KB limit for ONE stored proc in Oracl e 817

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 27 Jun 2002 16:01:59 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70249B192@lnewton.leeds.lfs.co.uk>


Per-Arne,

thanks for that, but unfortunately the user running the create is another user from the one that the create is taking place in. I don't like it myself, but until the app is changed, I'm stuck with it.

Cheers,
Norman.

PS. How's Norway today then ?



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: Per-Arne Hellarvik [mailto:phellarv_at_genuity.no] Posted At: Thursday, June 27, 2002 3:47 PM Posted To: server
Conversation: Has anyone heard of a 64KB limit for ONE stored proc in Oracle 817
Subject: Re: Has anyone heard of a 64KB limit for ONE stored proc in Oracle 81 7

On Thu, 27 Jun 2002 16:19:17 +0200, Norman Dunbar wrote:

Uh....I believe a GRANT EXECUTE ON <PROC> should do the trick without granting execute all.... Received on Thu Jun 27 2002 - 10:01:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US