Re: [cx-oracle-users] Optimizer Hints in Queries

[Andrew S. <saw...@gm...>]

After Mark responded, I went through the 2 scripts causing me issues again
and put back the hint using the /*+ hint */ syntax and reran my migration
scripts - this morning they've completed fine - so the hint was obviously a
red herring; sorry for the noise.  :/

Cheers,

Andrew

On Wed, Apr 18, 2012 at 1:04 AM, Amaury Forgeot d'Arc <ama...@gm...>wrote:

> 2012/4/17 Andrew Sawyers <saw...@gm...>
>
>> Fwiw - I just figured this out, using alternative syntax:
>> cursor.execute("select --+ hint \n count(food) from my_mv")
>> That appears to work.....is there any doc I am missing to read that talks
>> about what characters are illegal?  I have found trying to run multiple
>> statements in a single execute separated by ";" doesn't work with the
>> "illegal character" error....
>> Cheers,
>>
>
> This looks weird... /*+ has always worked for me.
> Can you paste the exact code that fails? There may be some other error.
> For example a trailing semicolon?
>
> --
> Amaury Forgeot d'Arc
>
>
> ------------------------------------------------------------------------------
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>