Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78HTY207679 for ; Fri, 8 Aug 2003 12:29:34 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78HTXp07672 for ; Fri, 8 Aug 2003 12:29:33 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h78F4jja006456 for ; Fri, 8 Aug 2003 08:05:56 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h78EjS73001000 for oracle-l@orafaq.net; Fri, 8 Aug 2003 07:45:29 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9A64; Fri, 08 Aug 2003 07:39:24 -0800 Message-ID: Date: Fri, 08 Aug 2003 07:39:24 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Rudy Zung Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Rudy Zung Subject: 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: text/plain Content-Transfer-Encoding: 7bit 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).