ODAC String/Varchar2 problem
ODAC String/Varchar2 problem
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
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
One more question...
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
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