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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 28 Jun 2002 09:33:02 +0100
Message-ID: <3d1c1f3e$0$225$ed9e5944@reading.news.pipex.net>

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7024A8E61_at_lnewton.leeds.lfs.co.uk...

> get this, when running the app, if a spacific function is chosen by
> the user, it then starts another connection to the database, and does
> something which instantly deadlocks with their original connection. This
> happened so often, that they 'fixed' it by putting an option on the
> app's menu to kill the second session - how's that then !

I'm beginning to think this group should come with a health warning. 'Reading posts with you morning coffee is not recommended due to splutter danger. You desk is at risk if you disregard this warning'

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Fri Jun 28 2002 - 03:33:02 CDT