Re: sql wrong? missing left parenthesis error?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 29 Nov 2002 11:14:09 +0100
Message-ID: <4efeuucnh3rfmschrm8mtdvc5gnqpplps4@4ax.com>

On Fri, 29 Nov 2002 02:20:38 -0500, "Madhu Shastrula" <Mshastrula_at_charter.net> wrote:

>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
>> *******************************************************

User is a pseudo-function returning the connected user. You need to rename the table, it is not going to work with whatever syntax

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 29 2002 - 04:14:09 CST