SQL*ReportWriter error (SELECT...INTO)

From: Mike Winterer <Michael.Winterer_at_jacobs.com>
Date: 1997/05/21
Message-ID: <33839E15.5805_at_jacobs.com>#1/1


We are having a problem SQL*ReportWriter (v. 1.1.14.16.1) used against Oracle 7.2.3.0.0. We have upgraded from SQL*ReportWriter (v.1.1.14.9.1) and Oracle 6.0.37.3.1. Operating system is HPUX. In the report in question we use the following type of statement in the FIELDS section of the report to load certain data needed for headers and such. In Oracle 6, this did not need the "rownum = 1", but now we get the error "ORA-02112: PCC: SELECT...INTO returns too many rows".

&SQL select units

[Quoted]              into :units 
         from sgal_wrk0
         where seq_num = &seq_num 
           and sub_seq  = &sub_seq
           and rownum = 1

I can find no other place other than the FIELDS section that this method is used. All existing occurances have been converted to include "rownum = 1". We still get this error. Apperently, Oracle 6 was not to particular about this issue. Or is it the SQL*ReportWriter that has a problem.

Is there anyone that has an idea of what could be wrong?

Mike Winterer
Michael.Winterer_at_jacobs.com

Definitions -

   Encryption : "A powerful algorithmic encoding technique employed in the creation of computer manuals." Received on Wed May 21 1997 - 00:00:00 CEST

Original text of this message