Re: 64K limit for stored procedures

From: Van Helleputte LUDO <ludo.van.helleputte_at_pandora.be>
Date: Mon, 01 Jul 2002 16:59:10 GMT
Message-ID: <yT%T8.7684$ix.1649@afrodite.telenet-ops.be>

This is tool and version dependant, I'm not sure about limits in the database, but I know that with some 'older' Development tools there were limits that were easily met with complex code ...

I also remember a bug with procedure builder and Oracle 7.1, ... if you had a syntax error in the cursor definition (declare section), and closed the window, it would save the code up to the error, ask you wether you were sure to close and if you responded Yes, you LOST all the rest of the code of the procedure ...

ALWAYS keep backups of your source code in flat files so that you can easily re-create them ...

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news: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 Mon Jul 01 2002 - 11:59:10 CDT