SQL Navigator hangs or crashes when working with Oracle nested tables.
Sometimes the error "Exception EOraError in module sqlnavigator.exe at XXXXXX"." appears.
To reproduce the error please follow the steps below:
1. Run the following script
CREATE OR REPLACE TYPE CourseList AS TABLE OF VARCHAR2(64);
CREATE TABLE department (
name VARCHAR2(20),
director VARCHAR2(20),
office VARCHAR2(20),
courses CourseList)
NESTED TABLE courses STORE AS courses_tab;
INSERT INTO department
(name, director, office, courses)
VALUES
('English', 'John Smith', 'Office 205', CourseList(
'Expository Writing',
'Film and Literature',
'Modern Science Fiction',
'Discursive Writing',
'Modern English Grammar',
'Introduction to Shakespeare',
'Modern Drama',
'The Short Story',
'The American Novel'));
commit;
2. Run a select query in the editor against table 'department'
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center