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

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 27 Jun 2002 19:05:52 +0400
Message-ID: <aff9kl$2jt$1@babylon.agtel.net>

Well, if you write some lenghty procedure and then wrap it, its size will most certainly exceed 64k. As far as I know there are limits on DIANA nodes, but I am not aware of any on source code size (at least not 64k).

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/e_lims.htm Gives a list of all PL/SQL limits, and also decrypts DIANA into something more meaningful (Descriptive Intermediate Attributed Notation for Ada).

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76939/adg10pck.htm#3359 9
also mentions some limits.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA70249A4C4_at_lnewton.leeds.lfs.co.uk...


> I've been told by a colleague, from one of our other offices, that

> Oracle 817 has a limit of 64KB as the size of a stored procedure's

> source code. Has anyone any details of this ?

>

> I've been through the 817 docs and not found anything that states this.

> If you know where it is, I'd appreciate a pointer please.

>

> The problem is, the app in question allows the users to create a

> document.

> This is stored as a stored procedure - which confuses the hell out of me

> as to exactly how they do it. When they want to recreate the doc, they

> just run the stored proc.

>

> I've got no idea of the internals of this system, it's a Forms thing and

> we don't have/use forms in this office.

>

> Thanks in advance.

>

>

> Regards,

> Norman.

>

> PS. I found out that in order for users to create the docs and run them,

> they *must have* CREATE_ANY_PROCEDURE and EXECUTE_ANY_PROCEDURE privs.

> Oh dear !

>

> I've already demonstrated how to trash a database with these privs alone

> - they didn't like me much after that !!!

>

> -------------------------------------

> 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

> -------------------------------------

>

Received on Thu Jun 27 2002 - 10:05:52 CDT