Devart Forums

Hello,

I have a question about Stored Proc.
ODAC : 5.80.0.38 for Delphi 7
Oracle Serve : Oracle 8.1.6
OCI: Version 9.0.1.1.1

I'm create scott.dout schema
--------------------------------------------------------------
CREATE OR REPLACE PROCEDURE DBOUT IS
BEGIN
dbms_output.put_line('ccccccccccccccccc');
END dbout;
---------------------------------------------------------------
// error code
procedure TForm1.Button1Click(Sender: TObject);
begin

With OraSession1 do
begin
ConnectString := 'scott/tiger@ORCL132';
Options.Net := False;
Options.UseOCI7 := False;
Connect;
end;
OraStoredProc1.Session := OraSession1;
OraStoredProc1.PrepareSQL;
//ora-03114 error
end;

//success code
procedure TForm1.Button2Click(Sender: TObject);
begin

With OraSession1 do
begin
ConnectString := 'scott/tiger@ORCL132';
Options.Net := False;
Options.UseOCI7 := True;
Connect;
end;
OraStoredProc1.Session := OraSession1;
OraStoredProc1.PrepareSQL;
end;

//success code
procedure TForm1.Button3Click(Sender: TObject);
begin
With OraSession1 do
begin
ConnectString := 'scott/[email protected]:1521:orcl2';
Options.Net := True;
Options.UseOCI7 := false;
Connect;
end;
OraStoredProc1.Session := OraSession1;
OraStoredProc1.PrepareSQL;
end;

I'm not unterstand UseOCI7

Could you explain me why ?

We couldn't reproduce this problem on Oracle Client 9.2.0.1. Can you try your sample on another version of Oracle Client.