PLS-00103 error [message #394413] |
Thu, 26 March 2009 22:12  |
bananaman
Messages: 71 Registered: March 2009
|
Member |
|
|
hi i'm trying to run the program written in my reference with the code below but i got an error that says: PLS-00103: Encountered the symbol "CREATE".
---==start of code==----
1 CREATE TYPE list_of_courses AS TABLE OF VARCHAR2(64);
2 CREATE TABLE department (
3 2 name VARCHAR2(20),
4 3 director VARCHAR2(20),
5 4 office VARCHAR2(20),
6 5 courses list_of_courses)
7* 6 NESTED TABLE courses STORE AS courses_tab;
SQL> /
---==end of code==----
Warning: Type created with compilation errors.
SQL> show errors
Errors for TYPE LIST_OF_COURSES:
LINE/COL ERROR
-------- ------------------------------------------
2/1 PLS-00103: Encountered the symbol "CREATE"
What wrong with this?
|
|
|
|
|
|
|
|