Devart Forums

Hello,

apparently we have the problem reported here if we try to execute an OracleScript with an OracleConnection in direct mode.

We are using OraDirect Version 4.0.14.

However, i was not able to find out how to increase the execution timeout - neither in OracleConnection not in OracleScript. Does somebody know how to solve this?

Thanks for any help!

Greetings - Richie

Unfortunately, there is no execution timeout currently.
We are going to provide appropriate property in the nearest future. It will be called OracleScript.CommandTimeout.

Alexey wrote:It will be called OracleScript.CommandTimeout.

Is this going to be the timeout for execution of the complete script? Or is this timeout value going to count for each command within the script?

It is going to be the timeout for maximum pause from a server during the execution of the script.

I see. Thank you for your information!

You are welcome.

Said property is implemented.
Look forward to the next build.

Hey Alexey,

I just downloaded the most current licensed version of OraDirect .NET Professional for .NET Framework 2.0 dated 25.06.07. The Version of CoreLab.Data.dll is 4.0.11.0 and the Version of CoreLab.Oracle.dll is 4.0.15.0.

However I still did not find the craved property OracleScript.CommandTimeout. Since the date of your post about acknowledgement that the property is implemented laid a few days before the release date of the most current library versions, I hoped that the property is already available.

When can I expect the first release that supports a command timeout in the class OracleScript?

Greetings - Richie

This was implemented on a base level (DbScript).

I see: Class DbScript is implemented in assembly CoreLab.Data.dll. The Timestamp of version 4.11.0 of this dll is 18.05.2007.

When can I expect the first release that supports a command timeout for class OracleScript?

CommandTimeout property is supported in this latest version. You'll see it in the Properties window.

Hello Alexey,

I downloaded the most current version of OraDirect .NET Professional version 4.00.16 (13.08.07). I still cannot find the "CommandTimeout" property - neither in class DbScript not in class OracleScript.

I try to find the property by investigating the OracleScript class in the Object browser. The IntelliSense has no knowledge about the Property as well. Also i added an OracleScript as component to a Windows.Forms class. The Properties window (right click on the "oracleScript1" component and selecting "Properties"), I find the Properties "Connection", "ScriptText", "GenerateMember" and "Modifiers", but no Porperty "CommandTimeout".

Actually, I still dont know how to access or modify the Command Timeout with the most current Version of OraDirect .NET Professional version 4.00.16 (13.08.07).

Would you be so kind and send me a sample project that set the CommandTimeout property or give me a step-by-step-explanation how to make the CommandTimeout property visible in the Properties window?

I noted that the version of assembly CoreLab.Data.dll is still 4.0.11.0. And since DbScript is implemented in there, could be possible that you use a more current version of the assemblies which are not accessible to me?

Greetings - Richie

It is strange that you don't see this property.
Anyway, we are going to release OraDirect .NET 4.20 tomorrow. Please wait a bit.