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

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Fri, 28 Jun 2002 22:07:54 +0200
Message-ID: <afig20$no9$1@news1.xs4all.nl>

This is a part of Metalink note Note:114019.1 Subject: Oracle8 and Oracle8i Database Limits

SQL Statement Length: maximum length of statements: 64K maximum; particular tools may impose lower limits

Stored Packages: maximum size: PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. Consult your PL/SQL or Developer/2000 documentation for details. The limits typically range from 2000-3000 lines of code.

Although not really stated, it looks you are near limits..

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> schreef in berichtnieuws 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 Fri Jun 28 2002 - 15:07:54 CDT