nvarchar2 & Direct mode

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

nvarchar2 & Direct mode

Post by sinys » Tue 11 Jun 2013 12:12

Delphi XE2, ODAC 9, Oracle 11, Direct mode

Code: Select all

create table SCOTT.ASDF
(
  podr NVARCHAR2(50)
);

insert into SCOTT.ASDF (PODR)
values ('Дом Екатеринбург-5 ПАРК ХАУС');

Commit;

select t.* from SCOTT.ASDF t;

PODR                                               
-------------------------------------------------- 
Дом Екатеринбург-5 ПАРК Х                          

1 row selected
Result: "Дом Екатеринбург-5 ПАРК Х" truncated string instead of the expected full-line.
If connect using oracle client this error is not.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Re: nvarchar2 & Direct mode

Post by bork » Wed 12 Jun 2013 10:19

Thank you for the information. We have fixed this bug, and this fix will be included in the next build. We can send you an ODAC build with the fix of this issue if you send us your IDE version and registration information by this form: http://www.devart.com/login.html

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: nvarchar2 & Direct mode

Post by sinys » Wed 12 Jun 2013 13:49

Please send me fixed version for XE2 (installer & source versions).
Thank you!
Last edited by sinys on Thu 13 Jun 2013 13:18, edited 1 time in total.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: nvarchar2 & Direct mode

Post by AlexP » Thu 13 Jun 2013 10:10

Hello,

I have sent you a fixed ODAC Src and Pro versions for RAD Studio XE2

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: nvarchar2 & Direct mode

Post by sinys » Wed 26 Jun 2013 13:39

For version that you sent when EurekaLog is activated and when I'm connecting with DirectMode I have next exception:

Code: Select all

Application has corrupted the memory: $0D5AFC30 DATA [? ()] 15 bytes.


[0040A8BC] System._DynArrayClear (Line 28545, "System.pas")
[00858AD4] OraNet.N_262.N_486
[00858AE4] OraNet.N_262.N_486
[00858A18] OraNet.N_262.N_486
[00861FA7] OraNet.N_873
[00886CC4] OraClasses.TOCIConnection.GetMaxStringSize (Line 3372, "OraClasses.pas")
[00888591] OraClasses.TOCIConnection.GetProp (Line 4212, "OraClasses.pas")
[0082D908] DBAccess.TCustomDASQL.AssignParam (Line 14436, "DBAccess.pas")
[008DA928] Ora.TOraSQL.AssignParam (Line 8716, "Ora.pas")
[007FE7F8] CRAccess.TParamDescs.GetItems (Line 4076, "CRAccess.pas")
[007F8AF9] CRAccess.TCRCommand.GetParam (Line 1720, "CRAccess.pas")
[0082D38C] DBAccess.TCustomDASQL.WriteParams (Line 14326, "DBAccess.pas")
[0081AD81] DBAccess.TCustomDADataSet.OpenCursor (Line 7256, "DBAccess.pas")
[008D710A] Ora.TOraDataSet.OpenCursor (Line 6978, "Ora.pas")
[007597B1] Data.DB.TDataSet.SetActive (Line 11314, "Data.DB.pas")
[0081ABAD] DBAccess.TCustomDADataSet.SetActive (Line 7200, "DBAccess.pas")
[007595F8] Data.DB.TDataSet.Open (Line 11270, "Data.DB.pas")
[00D13D89] UDM.TDM.InitCurrentUserObjects$22854$ActRec.$0$Body (Line 256, "UDM.pas")
[00B57DA4] OtlParallel.Parallel.Async$18493$ActRec.$0$Body (Line 1622, "OtlParallel.pas")
[00B4F71B] OtlTaskControl.TOmniTaskExecutor.Asy_Execute (Line 1630, "OtlTaskControl.pas")
[00B4EC12] OtlTaskControl.TOmniTask.InternalExecute (Line 1354, "OtlTaskControl.pas")
[00B4E980] OtlTaskControl.TOmniTask.Execute (Line 1274, "OtlTaskControl.pas")
[00B407F7] OtlThreadPool.TOTPWorkerThread.ExecuteWorkItem (Line 662, "OtlThreadPool.pas")
[00B40465] OtlThreadPool.TOTPWorkerThread.Execute (Line 628, "OtlThreadPool.pas")
[0040C7EC] SysInit._GetTls (Line 702, "SysInit.pas")
[004157EE] ELowLevel.EnableMemoryMapCaching (Line 1847, "ELowLevel.pas")
[004193EE] EMemLeaks._GetFramesCallStackDump (Line 779, "EMemLeaks.pas")
[00419654] EMemLeaks.CheckOurPointer (Line 944, "EMemLeaks.pas")
[00419CBA] EMemLeaks.EurekaFreeMem (Line 1487, "EMemLeaks.pas")
[004038B4] System.SysFreeMem (Line 2900, "GETMEM.INC")
[00419DA5] EMemLeaks.EurekaFreeMem (Line 1521, "EMemLeaks.pas") 
If connect using oracle client this error is not.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: nvarchar2 & Direct mode

Post by AlexP » Thu 27 Jun 2013 08:17

Hello,

We can't reproduce the problem. Please send a sample reproducing the problem with memory leak to alexp*devart*com

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: nvarchar2 & Direct mode

Post by sinys » Wed 24 Jul 2013 10:13

Hello,

to AlexP:
I think this is the same http://forums.devart.com/viewtopic.php?f=5&t=27572
I have already sent an e-mail with request and my licence information for fixed version, but I didn't get it. Please send me the fixed version (installer for XE2 and source).
Thank you.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: nvarchar2 & Direct mode

Post by AlexP » Thu 25 Jul 2013 13:27

Hello,

I have sent you a fixed ODAC versions for RAD Studio XE2

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: nvarchar2 & Direct mode

Post by sinys » Thu 25 Jul 2013 14:09

Thank you!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: nvarchar2 & Direct mode

Post by AlexP » Thu 25 Jul 2013 14:19

Hello,

Please let us know whether the problem is solved in the version we sent you.

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: nvarchar2 & Direct mode

Post by sinys » Fri 26 Jul 2013 08:16

I think this error is fixed because Eurekalog keep silent.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: nvarchar2 & Direct mode

Post by AlexP » Fri 26 Jul 2013 08:31

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

Post Reply