Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78IUGr12448 for ; Fri, 8 Aug 2003 13:30:16 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78IU6p12432 for ; Fri, 8 Aug 2003 13:30:08 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h78G6OW03677 for oracle-l@orafaq.net; Fri, 8 Aug 2003 09:06:24 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9A8C; Fri, 08 Aug 2003 08:59:24 -0800 Message-ID: Date: Fri, 08 Aug 2003 08:59:24 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Jamadagni, Rajendra" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Jamadagni, Rajendra" Subject: RE: Limits on PL/SQL block? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-895c82e3-1226-40b9-82f2-4e709b40009b" ------=_NextPartTM-000-895c82e3-1226-40b9-82f2-4e709b40009b Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C35DC6.67ABE3E3" ------_=_NextPart_001_01C35DC6.67ABE3E3 Content-Type: text/plain; charset="iso-8859-1" You want more cryptic answer ?? pl/sql block is limited by 64K Diana nodes. my guess is each node is a token. No one will tell you what a Diana node is, but it is used to parse pl/sql (after all it is modeled after ADA). Only solution, instead of testing the limits, break the long code into manageable chunks. The people who will maintain it will speak fondly about you. Raj ---------------------------------------------------------------------------- ---- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- Sent: Friday, August 08, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I'm seeing a "PLS-00123 program too large" error. Oracle's documentation says that the actual limit on the size of the block is dependant on the mix of statements in the PL/SQL block. Does anyone know how Oracle determines this limit? Is it a pure size of PL/SQL block in bytes, or is it number of unique statements in the block, or is it dependant on how much redo that the block may generate? (I know the recommended solution is to modularize and break up the statements into multiple blocks, but I'd like to know what are the limits to give us a better idea of determining where to break up the blocks dynamically, so the answer I'm really looking for is what is the limit or how Oracle determines the size limit, and not workarounds, which we're exploring anyway.) TIA ..Rudy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: rzung@printcafe.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C35DC6.67ABE3E3 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Limits on PL/SQL block?

You want more cryptic answer ??

pl/sql block is limited by 64K Diana nodes. my guess = is each node is a token. No one will tell you what a Diana node is, but = it is used to parse pl/sql (after all it is modeled after = ADA).

Only solution, instead of testing the limits, break = the long code into manageable chunks. The people who will maintain it = will speak fondly about you.

Raj
---------------------------------------------------------------= -----------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly = personal.
QOTD: Any clod can have facts, having an opinion is = an art !


-----Original Message-----
From: Rudy Zung [mailto:rzung@printcafe.com]
Sent: Friday, August 08, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Limits on PL/SQL block?



I'm seeing a "PLS-00123 program too large" = error. Oracle's
documentation says that the actual limit on the size = of
the block is dependant on the mix of statements in = the
PL/SQL block. Does anyone know how Oracle determines = this
limit? Is it a pure size of PL/SQL block in bytes, = or is
it number of unique statements in the block, or is = it
dependant on how much redo that the block may = generate?

(I know the recommended solution is to modularize = and
break up the statements into multiple blocks, but = I'd
like to know what are the limits to give us a = better
idea of determining where to break up the = blocks
dynamically, so the answer I'm really looking for = is
what is the limit or how Oracle determines the = size
limit, and not workarounds, which we're exploring =
anyway.)

TIA

..Rudy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rudy Zung
  INET: rzung@printcafe.com

Fat City Network Services    -- = 858-538-5051 http://www.fatcity.com
San Diego, = California        -- Mailing list = and web hosting services
---------------------------------------------------------------= ------
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB = ORACLE-L
(or the name of mailing list you want to be removed = from).  You may
also send the HELP command for other information = (like subscribing).

------_=_NextPart_001_01C35DC6.67ABE3E3-- ------=_NextPartTM-000-895c82e3-1226-40b9-82f2-4e709b40009b Content-Type: text/plain; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ESPN_Disclaimer.txt" *********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1 ------=_NextPartTM-000-895c82e3-1226-40b9-82f2-4e709b40009b-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni@espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).