Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Has anyone heard of a 64KB limit for ONE stored proc in Oracle 81 7
Niall,
sorry about that - hope there wasn't any important papers lying around :o)
I've done some more investigation and come up with this :
The user creates areport within the app, and this is stored (somewhere) as rtf. Details of the rtf are built into a proc. The proc also stores 'access paths' to any table used in the report. These simply define 'select <insert field here> from <insert table here> where <insert conditions here>' and there is one for each table. There may be more than one variable, but only one access path is stored. This is all compiled into the proc.
So, it isn't as bad as at first thought, but still not the worlds finest app :o)
Anyway, they've fixed it by advising that the report be split - and this works fine.
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com -------------------------------------
-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]
Posted At: Friday, June 28, 2002 9:33 AM
Posted To: server
Conversation: Has anyone heard of a 64KB limit for ONE stored proc in
Oracle 817
Subject: Re: Has anyone heard of a 64KB limit for ONE stored proc in
Oracle 817
>> 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:51:16 CDT