1 Reply Latest reply: Apr 2, 2010 10:08 AM by gdarling - oracle RSS

    CreateDynaset() and sql hint problem

      My Visual Basic 6 program try to use oo4o libray that bundel with instant client connect to server and call CreateDynaset() like

      Set rstORA = cnORA.CreateDynaset("select /*+ ALL_ROWS */ col1,col2,col3 from table",0)

      Client work correctly, it send string
      "select /*+ ALL_ROWS */ col1,col2,col3 from table"
      to execute

      But on client server show it execute statement
      "select col1,col2,col3 from table"

      I think it is a bug? Or what is special parameter must be set before call CreateDynaset()

        • 1. Re: CreateDynaset() and sql hint problem
          gdarling - oracle

          Are you sure this worked correctly in There's an old bug (4041790) where oo4o drops hints from updateable dynasets. The query actually gets issued twice when that's the case, are you checking both queries? The second one should be missing the hint.

          Anyway, some workarounds are:
          a) open the dynaset in read-only mode
          b) create a view with the hint and select from that instead.

          Hope it helps,