Optimizer hints in PL/SQL's embedded SQL

Hi, All,

When I write something like

procedure test is
  AId Integer;
begin
  SELECT /*+INDEX(E) */
    E.Id INTO AId
  FROM DocSpec E, .....
  .........
end;

SQL Engine absolutely ignores hint /*+INDEX(E)*/ Maybe PL/SQL quesses it's comments :-(((

I am forced to bypass the problem using EXECUTE IMMEDIATE

Is it the unique way? Does anybody know about specifying optimizer hint in in PL/SQL's embedded SQL?

Regards,
  Sergey Balter Received on Tue Oct 29 2002 - 02:29:43 CST