REP-0065: Virtual Memory System Error REP-0200: Cannot allocate enough memo
758008Apr 7 2010 — edited Apr 8 2010hi everyone,
i am getting this error because i am using ref cursors in the backend. my oracle reports builder version is 10.1.2.0.2.
when i run my RDF from reports builder it will run but when i try to go to last page then this error is thrown. its same thing happened when i tried to call from reports server for scheduling it fails and closes the database connection by not letting other reports created.
all i want is whatever i am putting in the backend in ref cursor , i want to put in program unit (stored procedure) in the RDF and attach this to attached libraries and refer this library in the RDF.
I dont know whether it is possible or not.
i can put in a procedure with some IN PARAMETERS AND SOME OUT PARAMETERS.
I DONT KNOW HOW TO DO THIS. i want is a stored procedure is created with some IN parameters AND with some OUT parameters.
after creating this procedure how to refer this procedure in the RDF.
please someone help in this. its very crucial for me.
its urgent .
please help asap.
can somebody tell me step by step with some examples or demos.
i really appreciate that..
THanks in Anticipation
Erat