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

Tom,

I know this doesn't help the original poster but am I right in thinking that this restriction is taken away in 9i?

Regards

--
Steve Rainbird
Principal consultant
MSS International Ltd.
www.mssint.com

Remove "nospam" from email address to reply

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message
news:affa1a012ql_at_drn.newsguy.com...


> 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

>