Error ParseSQL for create params

[sinys]

Delphi XE2, ODAC 8.1.6

For code in memo1

Code: Select all

begin
  -- Call the function
  :result := user1.package1.my_function1234(p_id_test => :p_id_test,
                                            p_sex => :p_sex,
                                            p_age => :p_age);
end;

I use this code:

Code: Select all

  OraSQL1.SQL.Text := Memo1.Text;
  OraSQL1.Params.ParseSQL(OraSQL1.SQL.Text, True);

and I see param with name "=" in params collection, it's no good, I think that this situation should be handled specially, and this param should not be.

If I set memo1 code in design time in OraSQL1 "SQL" page and go to "Parameters" page I'm not see param "=".

[AlexP]

hello,

The ParseSQL method is implemented in the standard Delphi DB.pas unit, and the problem when defining ":=" symbols as parameters is due to this method implementation. If you don't call this method, parameters will be defined correctly by us. You can contact RadStudio developers to have this bug fixed.

[sinys]

ok. Thank you.