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'
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center