Which version of iBATIS do you used ?
What is the exception ?
#PIE:varchar:String.Empty# ??
On 11/9/05, Angel Valero <[EMAIL PROTECTED]> wrote:
Hi, I am receiving the following exception when I pass
an empty string or null value to the database to a
field of type varchar2(x).
The Database is Oracle 9.2 and I'm using the Ms Oracle
Client. This is my providers.config:
<provider
name="ms-oracle"
enabled="true"
assemblyName="System.Data.OracleClient,
Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.OracleClient.OracleConnection"
commandClass="System.Data.OracleClient.OracleCommand"
parameterClass="System.Data.OracleClient.OracleParameter"
parameterDbTypeClass="System.Data.OracleClient.OracleType"
parameterDbTypeProperty="OracleType"
dataAdapterClass="System.Data.OracleClient.OracleDataAdapter"
commandBuilderClass="System.Data.OracleClient.OracleCommandBuilder"
usePositionalParameters = "false"
useParameterPrefixInSql = "true"
useParameterPrefixInParameter = "false"
parameterPrefix=":"
/>
And this is a little sample statement:
<update id="ActualizarGrupoPreguntas"
parameterClass="GrupoPreguntas">
update CUE_GPREGUNTAS set
ID_CUESTIONARIO =
#ID_CUESTIONARIO:number:0#,
PIE =
#PIE:varchar:String.Empty#,
where ID_GRUPREGUNTAS = #ID_GRUPREGUNTAS#
</update>
Any Ideas?
Thanks in advance.
Angel
______________________________________________
Renovamos el Correo Yahoo!
Nuevos servicios, más seguridad
http://correo.yahoo.es
