ERPstuff - Oracle EBS Community

Hello,

I have created a type & then a table to hold type as a column.


SQL>CREATE TYPE CourseList AS TABLE OF VARCHAR2(64)
SQL> /

Type created.

SQL> CREATE TABLE department (
2 name VARCHAR2(20),
3 director VARCHAR2(20),
4 office VARCHAR2(20),
5 courses CourseList)
6 NESTED TABLE courses STORE AS courses_tab
SQL> /

Table created.

SQL> desc department
Name Null? Type
------------------------------- -------- ----
NAME VARCHAR2(20)
DIRECTOR VARCHAR2(20)
OFFICE VARCHAR2(20)
COURSES COURSELIST

SQL> BEGIN
2 INSERT INTO department
3 VALUES('English', 'Lynn Saunders', 'Breakstone Hall 205',
4 CourseList('Expository Writing',
5 'Film and Literature',
6 'Modern Science Fiction',
7 'Discursive Writing',
8 'Modern English Grammar',
9 'Introduction to Shakespeare',
10 'Modern Drama',
11 'The Short Story',
12 'The American Novel'));
13 END;
14 /

PL/SQL procedure successfully completed.

SQL> select * from department;

NAME DIRECTOR OFFICE
-------------------- -------------------- --------------------
COURSES
----------------------------------------------------------------------------------------------------
English Lynn Saunders Breakstone Hall 205
COURSELIST('Expository Writing', 'Film and Literature', 'Modern Science Fiction', 'Discursive Writin
g', 'Modern English Grammar', 'Introduction to Shakespeare', 'Modern Drama', 'The Short Story', 'The
American Novel')

The problem is
=========
1. Now I want to display the data in Forms 6i. First in the data block wizard the type column is disabled by default. It can not be selected for display on the canvas. Please see the screen shot shown below......

[img]c:\NestedTable.bmp[/img]

Now how I can use the nested table in the oracle forms6i.