OraFAQ Forum: Reports & Discoverer » Report giving Cavaa 22 error

Home » Developer & Programmer » Reports & Discoverer » Report giving Cavaa 22 error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report giving Cavaa 22 error [message #88191]

Tue, 30 April 2002 02:17

Shrikanth
Messages: 16
Registered: April 2002

Junior Member

Hello guys,
i have a package having a ref cursor which select number of data from different views .. my select statement is having 3000 lines of codes.. now when i call this package with in my report 6i it gets compiled properly but when i run the reports it gives me
this error
rep0065 - virtual memory system error
and rep 0020 - unable to allocate memory cavaa 22

can any body help me how to rectify this problem..

thanks in advance

Report message to a moderator

Re: Report giving Cavaa 22 error [message #88194 is a reply to message #88191]

Tue, 30 April 2002 05:59

Smitha
Messages: 17
Registered: June 2001

Junior Member

Hi,
REF CURSOR in Reports is a very useful and tempting feature. But the bad news is that in 99.99% of the cases it does not work. There are lottsa bugs that Oracle has still to fix.
So try other alternatives if u have any.
Thanks and Regards,
Smitha

Report message to a moderator

Re: Report giving Cavaa 22 error [message #88196 is a reply to message #88194]

Tue, 30 April 2002 08:46

Smitha
Messages: 17
Registered: June 2001

Junior Member

Hi Shrikanth,
I had been struggling with the same issue for the past 2 days. I contacted Oracle and according to Oracle this is a bug in report builder which is not yet fixed.
If you want I can send you some material on this issue.
Try some alternatives, if u have (like lexical params...)
Smitha.

Report message to a moderator

Re: Report giving Cavaa 22 error [message #88200 is a reply to message #88194]

Thu, 02 May 2002 01:54

Shrikanth
Messages: 16
Registered: April 2002

Junior Member

thanks smita..
if you have any more details on this send send across to me. I will be greatfull to you. my email id is shrikanth.ramabadran@infrasofttech.biz

Report message to a moderator

Previous Topic:	Supported File formats for Oracle Reports (6i)
Next Topic:	Re: ORA-00904 in Oracle Discoverer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 03 07:11:58 CDT 2025