Page 1 of 1
SQLType doesn't work in direct mode
Posted: Thu 16 Jan 2014 19:10
by sinys
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.
Re: SQLType doesn't work in direct mode
Posted: Fri 17 Jan 2014 09:10
by AlexP
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.
Re: SQLType doesn't work in direct mode
Posted: Tue 25 Feb 2014 12:51
by sinys
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?
Re: SQLType doesn't work in direct mode
Posted: Tue 25 Feb 2014 13:45
by AlexP
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
Re: SQLType doesn't work in direct mode
Posted: Tue 25 Feb 2014 14:43
by sinys
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.
Re: SQLType doesn't work in direct mode
Posted: Thu 27 Feb 2014 11:17
by AlexP
We will try to add all operation codes in the following ODAC version.