Toad 13.3 - Eurekalog popup error

Toad for Oracle
1

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.

eureka01
eureka01818×724 156 KB

2

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?

3

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

5

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;
/
6

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.

7

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