Page 1 of 1

ODAC String/Varchar2 problem

Posted: Sun 30 Aug 2009 06:57
by A.Csaba
Dear, All!

I am developing an extproc library. In this library there is a function (WITH CONTEXT) which would like to returns 3000 chars length string. The memory allocation is OK. I have tested it. The parameter on the library side is OK, but in the database the return value has been truncated after the first cca 800 chars. The interesting thing is that this function works fine if i just remove the context.

I use Delphi7 and ODAC 6.50.0.39

Please help.

Thanks,

Csaba

Posted: Mon 31 Aug 2009 12:36
by A.Csaba
Sorry Guys, but i am still waiting for some kind of solution.
Because of this bug i am not able to move on.
Please someone check it out.

Thanks.

Csaba

Posted: Wed 02 Sep 2009 06:47
by A.Csaba
Hallo there!

Still waiting.... Please....

Posted: Thu 03 Sep 2009 08:21
by Plash
We could not reproduce the problem. Please send to support*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

One more question...

Posted: Mon 07 Sep 2009 07:22
by A.Csaba
First of all, thank you for the answer.

The second one: before I send you a small demo, is it possible to call the OCIExtProcAllocCallMemory() procedure. I would like to allocate memory for my pchar result. If I use getmem in delphi it works, but i am not able to release the allocated memory later, because i work through a dll from the database. My build of ODAC doesn't know this procedure. Is it possible to this?

Thanks,

Csaba
2005

Posted: Mon 07 Sep 2009 08:31
by Plash
Currently the OCIExtProcAllocCallMemory function is not declared in the OraCall unit. We'll add this function in the next ODAC build.

Replay

Posted: Mon 07 Sep 2009 14:26
by A.Csaba
Thanks for the qiuck answer.

When it will be released ?

Thanks

Csaba

Posted: Mon 07 Sep 2009 14:28
by A.Csaba
Sorry one more thing, because I am currently using ODAC 6.50, is it possible to backport the solution, or i should buy the new version ?

Posted: Tue 08 Sep 2009 08:55
by Plash
We are planning to release the new ODAC build this week. It is not possible to add the fix to the old ODAC version. You should renew your subscription and download the new version.