Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: AnyDac-Ora: StoredProc with params more than 512b?
AnyDac-Ora: StoredProc with params more than 512b?
Posted: 2007/06/05 00:02
 
Is it possible to execute stored procedure with params (strings) that has more than 512 chars?

in general - when i map such procedure (eg PROC_1), anydac by default map parameters - and for example PARAM1 (that is Varchar2(3000) on database side) become ADDataType: dtWideString, DataType: ftWideString;

If i pass parameter value that is shorter than 512 b - everything looks nice, but in any other way -

[AnyDAC][Phys][Ora]-1317. Data lenght [932] is too large for variable [ARAM1] (NOE10/VAR)

any comments would bed helpfull

inc
Re:AnyDac-Ora: StoredProc with params more than 512b?
Posted: 2007/06/05 00:16
 
Hello

What is database and national character sets ?

Regards,
Dmitry
Re:AnyDac-Ora: StoredProc with params more than 51
Posted: 2007/06/05 00:21
 
Server: Oracle10 XE
Client: Oracle10 (installed with XE server) / i've tested it also with client 9.x (and server 10)

NLS_LANG: POLISH_AMERICA.EE8MSWIN1250

regards
inc
Re:AnyDac-Ora: StoredProc with params more than 51
Posted: 2007/06/05 09:05
 
Hello

As quick workaround, open daADPhysOraclWrapper unit. Find there procedure AdjustByteSize. And just comment out completely it body.

Regards,
Dmitry
Re:AnyDac-Ora: StoredProc with params more than 51
Posted: 2007/06/07 23:00
 
hi,
i'll try this way;

thanks a lot for rapid solution

regards
inc