Re: strange sql command

It's the ampersand in your text string that is causing the problem. Because of it, SQL*Plus interprets mid as a user variable. Try issuing the SQL*Plus command SET DEFINE OFF prior to your query. That should eliminate the problem for you.

Best Regards,

Jonathan Gennick
mailto:jonathan_at_gennick.com
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

On Thu, 22 Mar 2001 07:54:53 +0100, "Marcel Stör" <marcel.stoer_at_complementa.ch> wrote:

>hi folks
>
>if i try to execute the following command oracle asks to enter the value for
>mid, since it obviously interpretes it as a keyword or built-in function:
>
>select oid, pid, p2maincat from t_product where p2maincat = 'Equity
>Switzerland Small & mid Cap';
>
>how to avoid this? i need to tell the database even more clearly that
>everything right from the = is one single string.
>
>cheers, marcel
>
>
>
Received on Thu Mar 22 2001 - 15:45:57 CST