There is no data type information provided next to the column name. Probably
that is the reason why the sql is failing. The constraint is also not
specified correctly.
"Sandy" <sandytschaefer_at_hotmail.com> wrote in message
news:1e05aa4d.0211180954.7f995291_at_posting.google.com...
> I can't see anything wrong with this sql statement but SQL*Plus
> doesn't seem to like it. Anyone else see something wrong?
>
> *****************************
> SQL> ed
> Wrote file afiedt.buf
>
> 1 CREATE TABLE kodUserSession (
> 2 SessionID
> 3 UserID
> 4 foreign key User
> 5 LogonStamp
> 6 LogoffStamp
> 7 IPAddress
> 8 constraint kodUserSession_PK PRI
> 9 )
> 10* tablespace KOD_DATA
> 11 /
> foreign key User
> *
> ERROR at line 4:
> ORA-00906: missing left parenthesis
> *******************************************************
Received on Fri Nov 29 2002 - 01:20:38 CST
