(Oracle Database 11g Release 22.214.171.124.0 - 64bit)
-- Create a type:
CREATE OR REPLACE FORCE TYPE mpa_subject_o AS OBJECT
-- 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
-- Write a simple SQL:
SELECT mpa_master_type (1 -- id
,mpa_subjects_t(mpa_subject_o (2, 'abc'))
-- 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.
Will SQLnav be able to work with types?
While the problem is not fixed - could I just get rid of the error message and continue working?