You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-cs@ibatis.apache.org by "Keslar, Jeremy" <Je...@am.sony.com> on 2005/05/17 19:27:59 UTC

Parameter Exception

I am receiving the following exception when I pass an empty string or
null value to the database to a field of type NVARCHAR2(50).

 

Exception:

Parameter ':PCBNumber': No size set for variable length data type:
String

 

Any ideas?

 

Jeremy

Re: Parameter Exception

Posted by Roberto R <ro...@gmail.com>.

Hi Jeremy. Which database are you using and what is the provider (Oracle 8i 
and the MS OracleClient with the 1.1 Alpha?)? Could you paste the contents 
of your SqlMap? 

If you're using Oracle and the 1.0 GA or 1.1 Alpha, try using a parameterMap 
and setting the parameter size.

Otherwise, if possible (if this is not a prod system yet), you can grab the 
latest source from SVN:

http://svn.apache.org/repos/asf/incubator/ibatis/trunk/

http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=70
http://apache.org/dev/version-control.html

Roberto

On 5/17/05, Keslar, Jeremy <Je...@am.sony.com> wrote:
> 
>  I am receiving the following exception when I pass an empty string or 
> null value to the database to a field of type NVARCHAR2(50).
> 
>  Exception:
> 
> *Parameter ':PCBNumber': No size set for variable length data type: String
> *
> 
>  Any ideas?
> 
>  Jeremy
> 
>