Devart Forums

Code: Select all

procedure TForm1.TestSession(aUseOci7: boolean);
var
  os1:TOraSession;
  q:TOraQuery;
  sp:TOraStoredProc;
begin
  os1:=TOraSession.Create(nil);
  os1.Username:='***';
  os1.Password:='***';
  os1.Server:='***';
  os1.Pooling:=False;
  os1.Options.UseOCI7:=aUseOCI7;
  os1.Connect;
  q:=TOraQuery.Create(nil);
  q.Session:=os1;
  q.SQL.Text:='select 1 a from dual';
  q.Open;
  ShowMessage(q.FieldByName('a').AsString);
  q.Close;
  sp:=TOraStoredProc.Create(nil);
  sp.Session:=os1;
  sp.StoredProcName:='DBMS_APPLICATION_INFO.read_module';
  sp.PrepareSQL;
  sp.Execute;
  ShowMessage(sp.ParamByName('module_name').AsString);
  os1.Disconnect;
  q.Free;
  sp.Free;
  os1.Free;
end;

Code: Select all

procedure TForm1.Button1Click(Sender: TObject);
begin
  TestSession(False); // all working fine
  TestSession(True);  // error on ANY procedure executing
end;

Code: Select all

First chance exception at $7600C42D. Exception class EOraError with message
'ORA-00002: Message 2 not found;  product=RDBMS; facility=ORA'.

Code: Select all

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, MemDS, DBAccess, Ora, StdCtrls;

type
  TForm1 = class(TForm)
    OraSession1: TOraSession;
    Button1: TButton;
    OraQuery1: TOraQuery;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Déclarations privées }
  public
    { Déclarations publiques }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  OraQuery1.Open;
  OraQuery1.Last;
  ShowMessage(IntToStr(OraQuery1.RecordCount));
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  OraSession1.Close;
end;

Code: Select all

object Form1: TForm1
  Left = 198
  Top = 116
  Width = 870
  Height = 640
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object Button1: TButton
    Left = 232
    Top = 56
    Width = 75
    Height = 25
    Caption = 'Button1'
    TabOrder = 0
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 472
    Top = 72
    Width = 75
    Height = 25
    Caption = 'Button1'
    TabOrder = 1
    OnClick = Button2Click
  end
  object OraSession1: TOraSession
    Options.UseOCI7 = True
    Username = 'storeland'
    Server = 'nttest-orcl'
    Left = 72
    Top = 112
    EncryptedPassword = '8CFF8BFF90FF8DFF9AFF93FF9EFF91FF9BFF'
  end
  object OraQuery1: TOraQuery
    Session = OraSession1
    SQL.Strings = (
      'select *'
      'from produits')
    Left = 344
    Top = 216
  end
end