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

In article <E2F6A70FE45242488C865C3BC1245DA70249A4C4_at_lnewton.leeds.lfs.co.uk>, Norman says...
>
>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 ?
>

it is false.

The limit has to do with the number of diana nodes (what plsql gets compiled into) and the code can exceed 64k.

some ENVIRONMENTS might limit you to a string of 64k but not the databsae.

>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 !

that is false as well. The owner of the procedure needs to simply GRANT EXECUTE on that procedure.

>
>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
>-------------------------------------
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp