Toad World® Forums

Crash with ANYDATA in table

Steps to reproduce:

CREATE OR REPLACE TYPE test_type AS OBJECT (
  id NUMBER,
  CONSTRUCTOR FUNCTION test_type RETURN SELF AS RESULT
);

CREATE OR REPLACE TYPE BODY test_type AS
  CONSTRUCTOR FUNCTION test_type RETURN SELF AS RESULT AS BEGIN RETURN; END;
END;

CREATE TABLE toad_test ( val ANYDATA );

INSERT INTO toad_test VALUES ( anydata.convertObject( NEW test_type() ) );

Then open the table in a describe window and switch to Data.

image

SELECT * FROM toad_test
produces similar error messages but does not seem to crash TOAD:

image

Hi Peter,

I get a different error message, but I get the same thing from SQL*Plus, so maybe what you're doing doesn't completely work in Oracle

image

Looks like your client is 12.2 while your database is 19.0, maybe this is the reason for your error?

It works with my SQL*Plus:

image

I have sent you my related Eureka-Log, maybe that helps.

Thanks, I can reproduce it now.

Fixed for next beta