Oracle 12c Select + Function FAIL

[sinys]

ODAC 9.3.10 XE2 Oracle 12c

Code: Select all

procedure TForm2.Button1Click(Sender: TObject);
begin
  OraScript1.SQL.Text :=
'WITH' + #13#10 +
'  FUNCTION with_function(p_id IN NUMBER) RETURN NUMBER IS' + #13#10 +
'  BEGIN' + #13#10 +
'    RETURN p_id;' + #13#10 +
'  END;' + #13#10 +
'SELECT with_function(1)' + #13#10 +
'FROM   dual' + #13#10 +
'/';

  ShowMessage(IntToStr(OraScript1.Statements.Count)); // SHOWED 3 instead 1
end;

In sqlplus this script is working well.

[AlexP]

Hello,

Thank you for the information. We have added support for 'WITH FUNCTION...' clause, this feature will be included to the next build.

[sinys]

ODAC 9.7.25
It doesn't work again.

[AlexP]

We will fix this behavior till the release of the next build