OraScript problems

[Iliev]

Hi,

I have several problems while migrating one of my projects to Delphi XE and ODAC 8.1.5 (I'm migrating from Delphi 2007 and ODAC 6.50).

I'm trying to execute this sql script from file (with empty lines too):

Code: Select all

connect "SYS"/"SYS_PSW"@"ORCL" AS SYSDBA;

connect "SYSTEM"/"SYSTEM_PSW"@"ORCL";

connect "SCOTT"/"TIGER"@"ORCL";

Problem #1: TOraScript raises "Range check error" at TDAScript.GetSQLText while parsing the file. The reason was a problem in TDAScriptProcessor.ExecuteNext. Just before call of "Reset" procedure only FOwner.FStartXXX fields are initialized but not FOwner.FEndXXX.

Problem #2: TOraScript can't connect as SYSDBA (first statement). The problem is in TOraScriptProcessor.DoBeforeStatementExecute where UsedConnection.ConnectMode is not set to be equal to AConnectMode (which is parsed in ParseConnectString few lines above).

[AlexP]

hello,

Problem #1) we didn't manage to reproduce this problem, when calling the OraScript.ExecuteFile method with indicating the file containing the commands specified by you, the error does not occur, please send your file to alexp*devart*com so that we could try to reproduce the problem with your file.

Problem #2) Thanks for the information, we have fixed this problem, this fix will be included in the next build.

[AlexP]

Hello,

Problem #1)
Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version

[AlexP]

hello,

The new ODAC version 8.2.7 including this fix is already available at our site