New version

[sinys]

the new ODAC version 9.1.3 is available for download now.

• Performance is improved
• Flexible management of conditions in the WHERE clause is added
• IPv6 protocol support is added
• The possibility to use ranges is added
• The AllowImplicitConnect option for the TOraSession component is added

Please more details for this items.
Need examples for use.

[AlexP]

Hello,

1) We have checked refactoring of the basic level to increase performance;
2) We have added the Condition property, that similarly allows to flexibly control Where conditions in DataSet;
3) We have supported working via the IPV6 protocol in the Direct mode;
4) We have added the possibility to filter DataSet by ranges, i.e., the expression

OraQuery1.Filter := 'deptno >=10 and deptno <= 20'

can now be replaced with

OraQuery1.IndexFieldNames := 'deptno';
OraQuery1.SetRange([10],[20]);

5) If the AllowImplicitConnect property is set to False and the TOraSession.Connected property is also set to False, when attempting to open DataSet (a stored procedure, etc.), the 'Connection is not connected' error will occur

[sinys]

cmNormal
cmSysDBA
cmSysOper
cmSysASM
How about SYSBACKUP | SYSDG | SYSKM?

[sinys]

I have request for syntax sugar
1) for OraPackage: OraPackage1.Params.ParamByName -> OraPackage1.ParamByName (like OraQuery) and the same for macros.
2) for TMacro: OraQuery1.MacroByName('...').Value := '' -> OraQuery1.MacroByName('...').Clear (like the same in ParamByName)

[AlexP]

Hello,

Thank you for the information, we will consider the possibility to add such functionality in the next versions.

[sinys]

Please add the button Code Editor to the front form

[AlexP]

Hello,

We have added all the features you suggested. These features will be included into he next ODAC release.

[sinys]

the new ODAC version 9.3.8 is available
*Possibility to assign external SvcCtx to connection is added
*SmartFetch mode for TDataSet descendants is added

How about description in documentation about this features?

[AlexP]

We have added description of the SmartFetch mode to the documentation: http://www.devart.com/odac/docs/devart_ ... tfetch.htm . Later we will make a post on the blog about how to work with this feature.
We will add description of the AssignSvcCtx method in the next version.

[senadp]

Hello.
Is it possible to have Devart Direct Oracle Access component in two different versions of RAD studio on the same computer ?

[AlexP]

You can install ODAC on several IDEs at a time on the same PC (for each IDE an individual installation file is used).

[JoaoMarcos]

Hi Alex,

I've been trying to use the SmartFecth mode, but every time I enable the feature I get an Ora Exception. How to use this feature, I think it could help us.

Thanks

[AlexP]

Please specify the case, when this problem occurs: at the moment of query execution, fetching data, etc. Also, please create a small sample demonstrating the problem and send it to alexp*devart*com

[JoaoMarcos]

Hi Alex,

I just want to know how to use, is there any documentation or the only thing I need to do is set the Enabled to True?

Does this feature have any prerequisites? (any permission on Oracle like the SmartRefresh mode)

Thanks,

[AlexP]

We have added description of the SmartFetch mode to the documentation: http://www.devart.com/odac/docs/devart_ ... tfetch.htm . Later we will make a post on the blog about how to work with this feature.