Home » Developer & Programmer » Reports & Discoverer » Print report with error REP-8: A run time error in the PL/SQL development environment (DE)
Print report with error REP-8: A run time error in the PL/SQL development environment (DE) [message #659635] Wed, 25 January 2017 02:21 Go to next message
Standa410
Messages: 1
Registered: January 2017
Junior Member
Hello,

I have problem with generate report to PDF via Report Server.
When generating a report show an error:

REP-8: A run time error in the PL/SQL development environment (DE)
PDE-PSD001 Could not resolve reference to <Unknown Program Unit> while loading <Unknown><Unknown>
REP-0008: An unexpected memory error occurred while initializing preferences.


The error occurs randomly. Once the report prints without problems and at a second printing report does not print and an error shown above,
although the report contains the same data.

My report use 3 Ref cursors and 3 select query. Use Report builder version 11.1.2.2.0.

Please, knows anyone where the problem is and how to resolve it?

Here is example, how I call Ref cusrcor:
Package:

TYPE t_info_rec IS RECORD  (
     column_1         	VARCHAR2(15)
    ,column_2         	NUMBER
    ,column_3         	DATE
    ,column_4         	VARCHAR2(15)
    ,column_5         	VARCHAR2(15)
  ); 

TYPE t_info_cur IS REF CURSOR RETURN t_info_rec;

PROCEDURE info(p_cur       IN OUT   t_info_cur
			   ,p_parameter_1        NUMBER
			   ,p_parameter_2        NUMBER
			   ,p_parameter_3        VARCHAR2
			   ,p_parameter_4        VARCHAR2
			   ,p_parameter_5        NUMBER
			   ,p_parameter_6        VARCHAR2);

Package Body:
PROCEDURE info(p_cur       IN OUT   t_info_cur
			   ,p_parameter_1        NUMBER
			   ,p_parameter_1        NUMBER
			   ,p_parameter_1        VARCHAR2
			   ,p_parameter_1        VARCHAR2
			   ,p_parameter_1        NUMBER
			   ,p_parameter_1        VARCHAR2)
  IS
    --
  BEGIN
    --
      OPEN p_cur FOR 
        SELECT column_1,column_2,column_3,column_4,column_5
			FROM table
			;
    
    --
  EXCEPTION
    WHEN OTHERS THEN
      RAISE;
      open p_cur for SELECT null,null,null,null,null FROM dual WHERE 1=0;
  END info;

Call Ref cusrsor from Report Builders in RDF file:

function QR_2RefCurDS return package.t_info_cur is
  c1 package.t_info_cur;
begin
  
  package.info(c1
     ,p_parameter_1	=>	:P_PARAM1
     ,p_parameter_2 =>  :P_PARAM2
     ,p_parameter_3	=>  :P_PARAM3
     ,p_parameter_4 =>  :P_PARAM4
     ,p_parameter_5	=> 	:P_PARAM5
     ,p_parameter_6	=> 	:P_PARAM6
     );
  return c1;   
end;

I am sorry for my English.

Thank you

Standa
Re: Print report with error REP-8: A run time error in the PL/SQL development environment (DE) [message #659637 is a reply to message #659635] Wed, 25 January 2017 03:01 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea, sorry, but I'm pretty much sure that this is wrong:
EXCEPTION
    WHEN OTHERS THEN
      RAISE;
      open p_cur for SELECT null,null,null,null,null FROM dual WHERE 1=0;
Nothing happens after RAISE, so this OPEN statement will never be executed.
Previous Topic: push button in report
Next Topic: report 11g arabic and english
Goto Forum:
  


Current Time: Thu Mar 28 04:15:22 CDT 2024