title: Convert the Highvalue of user_partition in varchar2
body: <pre><code>select SomeFunction(HIGH_VALUE)  
    from user_tab_partitions ;
  </code></pre>
  
  <p>while getting the scheme ,</p>
  
  <pre><code>desc user_tab_partitions;
  
  Name                   Null Type         
  ---------------------- ---- ------------ 
  TABLE_NAME                  VARCHAR2(30) 
  COMPOSITE                   VARCHAR2(3)  
  PARTITION_NAME              VARCHAR2(30) 
  SUBPARTITION_COUNT          NUMBER       
  HIGH_VALUE                  LONG()
  </code></pre>
  
  <p>HIGH_VALUE column of user_tab_partitions is stored as LONG datatype..still i am not able to convert that in varchar2..
  I am able to If i store that Highvalue using select into clause..but i want to pass that highvalue in function and get result back as varchar2..I have written below function but it doesnot work..</p>
  
  <pre><code>create or replace
  function SomeFunction(high_val LONG raw) 
  return varchar2
  is
     lHigh_value     LONG;
     strDate_clause  VARCHAR2(100);
  begin
     lHigh_value := high_val;
     strDate_clause := lHigh_value;
     return strDate_clause;
  end;
  </code></pre>
  
  <p>so please help me for solving the problem..
  thnks in advance..</p>