Oracle Database Discussions

Hi,

I have a problem with ORA-23620, "bind value size too large for PL/SQL CALL operation". The docs say that it occurs when you try to use a "bind string" longer than 4K for a stored procedure, called using "call". I have this SQL:

call MyPackage.MyProc(?, ?, ?, ?, ?, ?, ?, ?)

which I call several times in a batch update. The solution is supposed to be to use something like this instead:

BEGIN MyPackage.MyProc(?, ?, ?, ?, ?, ?, ?, ?); END;

I've changed my code to do that when there is one or more parameters in the batch that are longer than 1024*4 bytes. That did not help at all... what exactly is it that should be less than 4K? Is it the combined size of all parameters in the batch? And what does 4K mean? 4000 or 1024*4? And is it bytes or (unicode) characters they talk about?

Many thanks,

Micke

Edited by: user12218732 on Dec 1, 2009 2:17 PM