1 Reply Latest reply: May 30, 2012 5:01 AM by Amatu Allah Neveen Ebrahim RSS

    Only 1st character while fetching data through get_char_property

    visK
      Hi

      I am reading excel file through OLE2 object. while I am fatching data thr this utility It is fetching only first character of the string.


      procedure read_chr_cell( p_row number, p_col number, p_value in out varchar2 ) is
      args ole2.list_type;
      cell ole2.obj_type;
      begin
      args := ole2.create_arglist;
      ole2.add_arg(args, p_row );
      ole2.add_arg(args, p_col );
      cell := ole2.get_obj_property(worksheet,'Cells',args);
      ole2.destroy_arglist(args);
      p_value := ole2.get_char_property(cell,'Value'); [[[ PROBLEM AREA ]]]
      ole2.release_obj(cell);
      end;

      any advice is appreaciate

      Thanks
      Vishal