No size set for variable length data type: String

Wed, 09 Nov 2005 03:53:23 -0800 

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

Reply via email to