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

No Daniel. I would not say a stored proc is a SQL statement. What I posted was what I could find in the documentation and on Metalink about the issue.

It is not a clear description of the limit of a stored procedure or package. But is says something.
If they say a "typical limit" is 3000 lines of code and lets assume 80 characters/line the plain text max size for SOME tools is about 235K.

Daniel Morgan <dmorgan_at_exesolutions.com> schreef in berichtnieuws 3D1CCCBB.C7B684A7_at_exesolutions.com...
| Anton Buijs wrote:
|
| > 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
| > | -------------------------------------
| > |
|
| I see a possible apples and tractors comparison here.
|
| In one posting the statement is:
| "Oracle 817 has a limit of 64KB as the size of a stored procedure's source
| code."
|
| In another:
| "SQL Statement Length: maximum length of statements: 64K maximum"
|
| Are you saying that a stored procedure is a SQL statement?
|
| Daniel Morgan
|
Received on Sat Jun 29 2002 - 14:01:35 CDT