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.
SQLType doesn't work in direct mode
Re: SQLType doesn't work in direct mode
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.
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
Hello,
Why there are only 2 codes? What about other?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
Re: SQLType doesn't work in direct mode
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
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.
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
We will try to add all operation codes in the following ODAC version.