Home » Developer & Programmer » Reports & Discoverer » ITS URGENT PLEASE REPLY
ITS URGENT PLEASE REPLY [message #88192] Tue, 30 April 2002 02:42 Go to next message
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
Re: ITS URGENT PLEASE REPLY [message #88207 is a reply to message #88192] Mon, 06 May 2002 12:17 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
I think it hits shared pool problem ..becoz of the query length (3000 lines ..in a single query..enuf?;-))

if I were you, I wud do this..
since the package runs fine..Instead of returning the resultset (ref cursor) I wud rather create a database view at the backend.
The report query wud be based on the view and before report trigger calls the database package .

HTH
Oraboy
Previous Topic: Urgent!!!!!!!!pls help
Next Topic: Report to Excel
Goto Forum:
  


Current Time: Thu Mar 28 16:56:15 CDT 2024