BusinessObjects Board

SQL Override-Oracle Hints

building reports desktopintelligence
#1

Hi All,

I’m using V5.1. I want to override an existing data provider query with a query with oracle hints.
When I try to do this, error ORA-00911: invalid character appears

Would like to know if hints are allowed. If yes and any leads on solving the error

Thanks,
Meena

meenaj (BOB member since 2005-01-12)

#2

A search would have led you to lots of threads about hints… Try https://bobj-board.org/t/15442

jobjoris :netherlands: (BOB member since 2004-06-30)

#3

Hi,

You should be careful while overriding the SQL, perticularly on syntax of SQL. It will be helpful to provide the suggessions If you could provide the SQL.

bvrswamy :india: (BOB member since 2006-06-18)