Toad World® Forums

SQL nav 7.0.1: Cannot view SQL query results if DB types are involved

An example:
(Oracle Database 11g Release 11.2.0.3.0 - 64bit)

-- Create a type:

CREATE OR REPLACE FORCE TYPE mpa_subject_o AS OBJECT
(id NUMBER
,description VARCHAR2(255)
);

-- Create a type which is a table of previous created type:

CREATE OR REPLACE TYPE mpa_subjects_t IS TABLE OF mpa_subject_o;

-- Create a type which contains simple columns and a type based that is table of types:

CREATE OR REPLACE TYPE mpa_master_type AS OBJECT
(
id NUMBER,
subject mpa_subjects_t
);

-- Write a simple SQL:
SELECT mpa_master_type (1 -- id
,mpa_subjects_t(mpa_subject_o (2, 'abc'))
)
FROM DUAL;

-- Open the selected field and the system loops on a message:

-- Could not convert variant of type (Unknown) into type (OleStr)

The only way to close the message is to force SQL Navigator to shut down.

  1. Will SQLnav be able to work with types?

  2. While the problem is not fixed - could I just get rid of the error message and continue working? :slight_smile:

Hi Martin,

Many thanks for reporting this issue for us.

We have raised SQLNAV-1516 for it and will fix in the first beta of 7.1.

Thanks again,

Shirly

Hi Martin,

The beta build is ready with this issue fixed now, you can go to beta overview page to download and have a check now, thanks.

Thanks, works like a charm [Y] [<:o)]