CODEWITHSUNDEEP
sqloracle-databasedelphifiredac
Niko
Niko

Reputation: 79

FireDAC could not handle parameter names longer than 30 chars

I use Oracle database version 19.3.0 and it can handle parameter names longer than 30 chars. If I execute in Delphi FireDAC-procedure "ExecProc" to call Stored Procedure in SQL, Delphi throws "ORA-01036 : illegal Variable name/number" exception and calling of the procedure terminates prematurely, because one parameter name is longer then 30 chars. Is there some FireDAC property to change this behavior without changing parameters name length?

"C:\Program Files (x86)\Embarcadero\Studio\19.0\source\data\firedac\FireDAC.Phys.Oracle.pas" FireDAC.Phys.Oracle

Upvotes: 2

Views: 538

Answers (1)

Niko
Niko

Reputation: 79

Solution: Change pbByName to pbByNumber

procedure TForm5.Button1Click(Sender: TObject); begin
FDStoredProc1.ParamBindMode := pbByNumber;
FDStoredProc1.FetchOptions.Items := [fiBlobs, fiDetails]; //This disables automatic fetching of parameters from server
FDStoredProc1.Params.CreateParam(ftString,'Averylongparamternamethathopefullyislongerthanthirtycharacters',ptInput);
FDStoredProc1.params.CreateParam(ftString,'outparam',ptOutput);
FDStoredProc1.Params[0].AsString := 'Hello World';  

FDStoredProc1.ExecProc; 

ShowMessage(FDStoredProc1.Params[1].AsString);
end;

Upvotes: 1

Related Questions