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.
-
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?