Re: Error 'Column not allowed here' (ORA-984) through SQL-Pro*C

From: <Herman_Mantzke_at_dci-ltd.com>
Date: Wed, 24 Feb 1999 19:11:51 GMT
Message-ID: <7b1itg$43o$1@nnrp1.dejanews.com>

Double quotes (") are used for aliases, string substitutions for SQLPLUS command line.

Single quotes (') are used for string literals, string substitutions for actual values.

Herman
In article <36D18026.A666BE17_at_eurocontrol.fr>, Serge LUCAS <Serge.Lucas_at_eurocontrol.fr> wrote:
> I sometimes obtain the 'quoten in subject' error code with my SQL-Pro*C
> code.
> did someone already get these error message ?
> This error seems to happen also in SQL-plus, when I try to insert a
> string in double-quotes("xxx") instead of simple-quotes('xxx').
> [INSERT INTO A VALUES("xxx");]
>
> May this be an explaination ? In this case, how to force the SQL command
> to understand simple-quotes ?
>
> --
> Serge LUCAS
> STERIA ATM/Eurocontrol
> BS-012
> Tel 01 69 88 74 15
> Fax 01 69 88 73 33
> Mel lua_at_eurocontrol.fr
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 24 1999 - 13:11:51 CST