TOO_MANY_ROWS in 7.0

[Sergey Rudyshin]

Steps of reproducing an error:

1) Create in DB following function

CREATE OR REPLACE FUNCTION too_many_rows_ex RETURN VARCHAR2
IS
BEGIN
    RAISE TOO_MANY_ROWS;
    RETURN 'str';
END;

2) In sql window execute

SELECT too_many_rows_ex FROM dual

The exeption is absent.

If execute in Oracle SQLPlus

SELECT too_many_rows_ex FROM dual
SQL> SELECT
  2      too_many_rows_ex
  3  FROM
  4      dual;
    too_many_rows_ex
    *
ERROR at line 2:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RHONDA.TOO_MANY_ROWS_EX", line 5

PL/SQL Developer
Version 7.0.0.1050 (MBCS)
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 785,900 kB (101,772 available)
Paging file : 1,527,576 kB (968,432 available)
Virtual memory : 2,097,024 kB (1,924,308 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Dual
OCI Library:
Use OCI7: False

Plug-Ins
*PL/SQL Developer FindAll Plug-In version 2003/11/18 (C:\Program Files\PLSQL Developer\PlugIns\FindAll.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
PL/SQL Developer Scale Plug-In version 2003/11/13 (C:\Program Files\PLSQL Developer\PlugIns\Scale.dll)
*PL/SQL Developer Sort Plug-In version 2003-11-05 (C:\Program Files\PLSQL Developer\PlugIns\Sort.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
EXTPROC_CONNECTION_DATA
TITAN

Homes
OraClient10g_home1 (D:\Oracle\product\10.1.0\Client_1)
OraHome81 (D:\oracle\ora81)

DLLs
D:\Oracle\product\10.1.0\Client_1\bin\oci.dll

TNS File
D:\Oracle\product\10.1.0\Client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: D:\Oracle\product\10.1.0\Client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Character size: 1 byte(s)

 

[LMW]

Hello,

this happens also in Version 6.0.6.

It seems, that also the exception NO_DATA_FOUND is captured by the SQL-Window and COMMAND-Window functionality.

 

[Marco Kalter]

We'll check it out. These exceptions should of course not be hidden.