Proxy user in Direct mode

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ahsan.khan
Posts: 2
Joined: Wed 22 Oct 2014 11:27

Proxy user in Direct mode

Post by ahsan.khan » Wed 22 Oct 2014 11:36

Hi,
I am trying to use the following code to connect to Oracle DB in Direct Mode but in second session Connect I cannot. OCI_INVALID_HANDLE exception. Please help

Thank you,

Orasession1 := TOraSession.create(self);
Orasession1.Options.Direct := true;
Orasession1.Username := 'ORA_PROXY';
Orasession1.Password := 'P@55w0rd';
Orasession1.Server := 'lnx-dbdev:1522:sid=oradb';
Orasession1.Connect;

OraSession2 := TOraSession.create(self);
OraSession2.Server := OraSession1.Server;
OraSession2.ProxySession := OraSession1;
OraSession2.UserName := 'ORA_ADMINISTRATOR';
OraSession2.Connect;

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Proxy user in Direct mode

Post by AlexP » Thu 23 Oct 2014 05:04

Hello,

The ProxySession feature not supported in Direct mode.

ahsan.khan
Posts: 2
Joined: Wed 22 Oct 2014 11:27

Re: Proxy user in Direct mode

Post by ahsan.khan » Thu 23 Oct 2014 09:22

Okay then how do I login as proxy user in direct mode?
i.e.
ORA_PROXY[ORA_ADMINISTRATOR]

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Proxy user in Direct mode

Post by AlexP » Fri 24 Oct 2014 05:47

Such functionality (login as proxy user) is not supported in Direct mode.

Post Reply