| ITS URGENT PLEASE REPLY [message #88192] |
Tue, 30 April 2002 02:42  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
