OraScript problems
Posted: Thu 03 May 2012 14:37
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):
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).
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 #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).