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

[Amaury F. d'A. <ama...@gm...>]

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