5 Replies Latest reply on Mar 18, 2005 7:30 AM by te*437737*no

    problem with OCINumber and OCIBindByPos - ORA-01458: invalid length inside

    97240
      Hello,
      I want to bind an output variable via OCIBindByPos (please see code below) but I get this error:

      'ORA-01458: invalid length inside variable character string'

      It seams that a size of 22 for OCINumber is not correct?!

      thx,
      Oliver

      ...

      OCINumber data;
                
      if ( OCIBindByPos(
      stmt_hndl,
      & bind_hndl,
      err_hndl,
      static_cast< ub4 >( position),
      static_cast< dvoid * >( & data) ),
      static_cast< sb4 >( 22), // correct value ????
      SQLT_VNU,
      0,0,0,0,0,OCI_DEFAULT) != OCI_SUCCESS)
      throw sql_exception( err, "bind parameter by position");