9 Replies Latest reply on Nov 28, 2012 11:42 PM by 935660

    making apex_util.get_print_document return an error message

    935660
      We are using apex_util.get_print_document in a process to run a report something like this:
      declare
         l_report blob := null;
      begin
          
          l_report := apex_util.get_print_document (
              p_application_id      => :APP_ID,
              p_report_query_name   => 'report_query_name',
              p_report_layout_name  => 'report_layout_name',
              p_report_layout_type  => 'rtf',
              p_document_format     => 'rtf'
          );
        
         if l_report is not null and dbms_lob.getlength(l_report) > 0 then
        
            apex_application.g_print_success_message := 'Report Created.<br>';        
            INSERT INTO reports (attachment, date_created, filename, mime_type) 
            VALUES (l_report, sysdate, 'report.rtf', 'text/rtf' );        
         else        
            apex_application.g_print_success_message := '<span style="color:#CC0000">There was a problem creating the report.</span><br>';    
         end if;  
      end;
      And this works well most of the time. The problem is, if the report fails for some reason, apex_util.get_print_document gives no information whatsoever as to what went wrong. Is there any way at all we can find out what the problem was?

      Application Express 4.0.2.00.07
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production