SQLType doesn't work 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
sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

SQLType doesn't work in direct mode

Post by sinys » Thu 16 Jan 2014 19:10

OraQuery1.SQL.Text := 'create materialized view test as select 1 id from dual';
OraQuery1.Execute;
OraQuery1.SQLType show correctly code in Oracle client mode and always show 0 in direct mode.

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

Re: SQLType doesn't work in direct mode

Post by AlexP » Fri 17 Jan 2014 09:10

Hello,

For the time being, this feature is not supported in the Direct mode. We will consider the possibility to support retrieving of correct command codes in one of the next versions.

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: SQLType doesn't work in direct mode

Post by sinys » Tue 25 Feb 2014 12:51

Hello,
the new ODAC build 9.2.6
In this version:
Returning SQL Command Code for CREATE TABLE & DROP TABLE in the Direct Mode is added
Why there are only 2 codes? What about other?

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

Re: SQLType doesn't work in direct mode

Post by AlexP » Tue 25 Feb 2014 13:45

In future, we are going to support all operation codes. If you need any operation codes urgently, please specify them - and we will try to add them in the next build

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: SQLType doesn't work in direct mode

Post by sinys » Tue 25 Feb 2014 14:43

What is the problem to add all the codes at once? If you need codes I have them.
First of all I would like to process the codes for commands create/alter/drop of popular types of objects like packages, functions, procedures, views, mat views etc.

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

Re: SQLType doesn't work in direct mode

Post by AlexP » Thu 27 Feb 2014 11:17

We will try to add all operation codes in the following ODAC version.

Post Reply