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

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 Fri Jun 28 2002 - 15:53:46 CDT