SQL*ReportWriter error (SELECT...INTO)
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