This discussion is archived
1 Reply Latest reply: May 30, 2012 3:01 AM by Amatu Allah RSS

Only 1st character while fetching data through get_char_property

visK Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points