Create Table Error -- Help Please

Hello everyone.

I'm running Oracle 8.0 on NT4 (yep thats right) and running SQL*Plus
8.03.

I'm typing the following at the SQL*Plus prompt:

1. Create Table EMPLOYEES
2. (
3. FName VARCHAR(15) NOT NULL,
4. MINIT CHAR,
5. LName VARCHAR(15) NOT NULL,
6. SSN CHAR(9) NOT NULL,
7. BDATE CHAR(25),
8. Address VARCHAR(30),
9. Sex CHAR,
10. Salary DECIMAL(10,2),
11. SUPERSSN CHAR(9),
12. DNO INT,
13. Primary Key(SSN),
14. Foreign Key(SUPERSSN) REFERENCES EMPLOYEES(SSN),
15. Foreign Key(DNO) REFERENCES DEPARTMENT(DNUMBER)
16.);

I receive the following error:

"ORA-0091:invalid Character" line 16

Can anyone suggest why I'm getting this error ? I've tried removing the
character (semi-colon) but then I get a error ("missing or invalid
option line 16" )for the next Create Table ... statement that follows.
I've tried replacing it with a comma (,) but this gives the same error
as "missing or invalid option line 16".

Thanks very much for your time. Any help would be appreciated.

Victor

re: Create Table Error -- Help Please

Hi Victor,

I have just copied and pasted your script and it works well. The table
was created successfully.

There may be an invisible character in your script.

I reccommend you to write your script in a file and start from there.

@c:\scr.sql


best regards....

re: Create Table Error -- Help Please

Hi Victor,

I have just copied and pasted your script and it works well. The table
was created successfully.

There may be an invisible character in your script.

I reccommend you to write your script in a file and start from there.

@c:\scr.sql


best regards....