Re: ORA-00920 invalid relational operator

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Mon, 4 Jul 2005 09:10:23 -0700
Message-ID: <wKKdnf_26pDpwlTfRVn-uQ@comcast.com>

<olivier.duhart_at_gmail.com> wrote in message news:1120484025.720625.185130_at_o13g2000cwo.googlegroups.com... Thanks Billy and Morgan.

Morgan : This query is only an example, I generate it dynamically and though region and holding may not be ignored in the [AND e.region||'.'||e.subregion||'.'||e.holding LIKE '%.24.%'] part Same remark for sgmversion and typologyversion but I should have explained
the context of this query, shame on me.

Billy : Well I absolutely don't know what a bind variable is. Could you explain or give a little example please ?

Thanks both

Olivier

Olivier,
Read Tom Kyte's books or read the docs. (Oracle Application Developer's Guide at otn.oracle.com) All databases that I have experience with allow the use (and encourage) the use of bind variables, also known as host variables or parameters to a query. (In Java usually denoted by a ?) Bind variables are not new and not unique to Oracle. Jim Received on Mon Jul 04 2005 - 11:10:23 CDT