stored procedure writing directly in RMS

Is there any examples of writing stored procs directly in RMS? For example I have a stored procedure I have written that gets fired off from CR8.5. The stored proc has one section that does an insert into a temp table and at the end of the stored proc does a select of the temp table. Any time within the stored proc when doing an insert the last select does not work. If I do not do an insert within the stored proc everything works as normal. I even tried having my stored proc call another stored proc when it gets done, but because of that insert it has problems. Is there anything written anywhere or documented about some of the issues with stored proc writing directly into RMS? Thanks