Re: Table and column with same name, fails only if using bind parameter
Date: 6 Feb 2003 13:56:57 -0800
Message-ID: <27270a53.0302061356.109a738_at_posting.google.com>
"Nick Havard" <jimbojones_at_jimbo.com> wrote in message news:<UUt0a.145$%F5.113_at_newsfep3-gui.server.ntli.net>...
> Hi,
>
> Without meaning to be patronising, have you checked all the data types being
> used. In first query you are using a number inside a set of quotes. What
> datatype is p_price_lev (if it is fixed length comprisons may not work) What
> datatype is the column pricing_level, NUMBER, CHAR, VARCHAR2 etc.
>
> The names shouldn't be causing a problem, if you think they are alias the
> table name.
>
> Regards.
>
> Nick Havard
The column is CHAR(4); the bind parameter is also CHAR(4). I posted a SQL*Plus spool file elsewhere in this thread, in which I tried a table alias, to no avail. Any ideas? Thanks. Received on Thu Feb 06 2003 - 22:56:57 CET