Toad World® Forums

Toad 13.3 - Eurekalog popup error

I get this weird popup after execute a select statement which returns the result as an Oracle TYPE. Also 13.2 is affected,with the same result.

That error message above does not give enough info for us to solve it.

Can you provide a script to create a sample table with data so we can reproduce the error?

I sent you the requested DDL and some sample data, offline.

Incase anyone else is following this, here is some additional information:

  1. it happens only in 64 bit
  2. you can reproduce it with the following, after creating the objects below:

SELECT TYPE_LEVEL1(890480363, 888445111, type_level2(1, 's')) from dual;

drop type type_level1;
drop type type_level2;

CREATE OR REPLACE TYPE TYPE_LEVEL2 AS Object
( a_number number,
  a_varchar2 varchar2(40),
  CONSTRUCTOR FUNCTION TYPE_LEVEL2 RETURN SELF AS RESULT
 );
/

CREATE OR REPLACE TYPE BODY TYPE_LEVEL2 IS
  CONSTRUCTOR FUNCTION TYPE_LEVEL2
  RETURN SELF AS RESULT
  IS
  BEGIN
    RETURN;
  END TYPE_LEVEL2;
END;
/

CREATE OR REPLACE TYPE TYPE_LEVEL1 AS Object
( a_number number,
  b_number number,
  a_type_level2 type_level2,
  CONSTRUCTOR FUNCTION TYPE_LEVEL1 RETURN SELF AS RESULT
)
/

CREATE OR REPLACE TYPE BODY TYPE_LEVEL1 IS
  CONSTRUCTOR FUNCTION TYPE_LEVEL1
  RETURN SELF AS RESULT
  IS
  BEGIN
    self.a_type_level2 := type_level2(0, null);
    RETURN;
  END TYPE_LEVEL1;
END;
/

Hi @JohnDorlon,

I also have a EurekaLog error for a table created by a colleague in my schema: "Fixed row count must be less than row count"

EurekaLog 6.0.22
Application:
-------------------------------------------------------
** 1.1 Start Date : Thu, 26 Mar 2020 15:53:03 +0800**
** 1.2 Name/Description: Toad.exe - (Toad for Oracle)**
** 1.3 Version Number : 10.5.1.3**
** 1.4 Parameters : **
** 1.5 Compilation Date : Wed, 12 May 2010 00:21:33 +0800**
** 1.6 Up Time : 8 hours, 46 minutes, 54 seconds**
Exception:
------------------------------------------------------------------
** 2.1 Date : Fri, 27 Mar 2020 00:39:57 +0800**
** 2.2 Address : 00640359**
** 2.3 Module Name : Toad.exe - (Toad for Oracle)**
** 2.4 Module Version: 10.5.1.3**
** 2.5 Type : EInvalidGridOperation**
** 2.6 Message : Fixed row count must be less than row count.**
** 2.7 ID : 96BA**
** 2.8 Count : 1**
** 2.9 Status : New**
** 2.10 Note :**

So when I checked this particular table, NUM_ROW is only up to 180. I am unable to find any forum here or by Googling, so how do I update it to accommodate more rows? I expect it to have more than 180. The error happened when I use Import Data to add more records into the said table.

Thank you for guidance.

Hi Leslie,

This is a very different problem. Please start a different thread in the forum for it.

I see you are using Toad version 10.5. This is a very old version, but I have not heard of this error message before. Can you give me some steps to recreate it? (Again, in a different thread please)

-John