Devart Forums

Posted: **Mon 04 Jun 2012 19:58**

Delphi XE2, ODAC 8.1.6

For code in memo1

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 "=".

Posted: **Tue 05 Jun 2012 10:02**

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.

Posted: **Tue 05 Jun 2012 12:00**

ok. Thank you.

Devart Forums

Error ParseSQL for create params

Error ParseSQL for create params

Re: Error ParseSQL for create params

Re: Error ParseSQL for create params