Has anyone heard of a 64KB limit for ONE stored proc in Oracle 81 7

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

Vladimir,

thank you for the referneces - funny the search enging in the docs never found them.

I've passed the info on to my colleague. It appears that DIANA might be the problem - and not a 64Kb limit on source.

Regards,
Norman.

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: Vladimir M. Zakharychev [mailto:bob_at_dpsp-yes.com] Posted At: Thursday, June 27, 2002 4:06 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 817

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. Received on Thu Jun 27 2002 - 10:32:11 CDT